Answer for:

TSQL If/When issue

Message 8 of 8

View entire thread
0 Votes




it might need to go closer to your "when"..not sure..
however, as i said, was just a thought, its actually been a while since used exists and can't rememebr the correct usage of it :)

i maybe be around this weekend and can play around with it..
but Tony's idea's are sound.
I'd likely take a similar approach to him, break it down, use a very basic trigger..use a table...