Answer for:

TSQL If/When issue

Message 6 of 8

View entire thread
0 Votes

I changed [else 0] to else 0... still get 'Incorrect syntax near the keyword 'then'.' Thinking I need to find an alternate way to do this like you suggested. Don't have a ton of experience with temporary tables - this will be interesting.