@@@@@ Calling Sql Server Developers, Or Idea Vunna Vallu @@@@@

[Kakateyudu]

AND(i.reviewed_by <> d.reviewed_by OR i.pdf_filename <> d.pdf_filename)

Paina script lo i is inserted and d is deleted, trigger lo oka line adhi......

deleted value null ina sare trigger avvali and space or blank vunna trigger avvali trigger..

deleted value(old value) blank or space vunte trigger avtundhi, but old value null vunte trigger avvatla

Old value and new value same vunna trigger avvakudadhu...... paina statement andhuke

em logic add seyyalo kasta seppandi vayya

[Kakateyudu]

[baluabcdefgh]

Help

[Kakateyudu]

[Kakateyudu]

[Kakateyudu]

[scootergofast]

OR d.DELETEDVALUE IS NULL ani pettu ... aa bracket lo

[scootergofast]

" d.reviewed_by IS null" ani try chey

[Kakateyudu]

thank you got that

[mtkr]

[scootergofast]

[quote name='Kakateeyudu©' timestamp='1334860119' post='1301660472']
thank you got that
[/quote]
raakinav kani etla achindi chepehe ... maku kuda teluthadi kada

[scootergofast]

anna help anav .. cheppamanav .. akariki achidi annav .. antha sagam sagam chepi pothe geeda janalu em kavale ..

[PMREDDY19]

[quote name='Kakateeyudu©' timestamp='1334860119' post='1301660472']
thank you got that
[/quote]

[scootergofast]

[quote name='PMR aka OM' timestamp='1334860706' post='1301660538']

[/quote]
kadha evadu em seppaledu ... kani achindi annadu .. malla AFDB rock annadu endho emo [img]http://lh5.ggpht.com/-NknRuiRzcgw/TmBTvqAGEmI/AAAAAAAAD9s/EdxXvpMH6-Q/Brahmi-4.gif[/img]

[Kakateyudu]

[quote name='scootergofast' timestamp='1334860903' post='1301660552']
kadha evadu em seppaledu ... kani achindi annadu .. malla AFDB rock annadu endho emo [img]http://lh5.ggpht.com/-NknRuiRzcgw/TmBTvqAGEmI/AAAAAAAAD9s/EdxXvpMH6-Q/Brahmi-4.gif[/img]
[/quote]
AND(ISNULL(i.reviewed_by,'') <> ISNULL(d.reviewed_by,'') OR ISNULL(i.pdf_filename,'') <> ISNULL(d.pdf_filename,'')); \

baa sudaled posts