Tuesday, January 27, 2015

Alternate to multiple IF statements

This is repetetive to write 20 IF statements that's the reason, what i was asking is any alternate for these many IF statements.


With out IF OR With out Dynamic SQL


CASE @ReportName=1


go select 'First dataset '


CASE @ReportName=2


go Select 'second dataset '



No comments:

Post a Comment