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