Tuesday, January 27, 2015

Alternate to multiple IF statements

Please take a look

declare @sqlstr varchar(1000),
@reportname int;

set @reportname =4;

SET @sqlstr= CHOOSE ( @reportname, 'First dataset', 'second dataset ', 'third dataset ', 'Fourth dataset' ) ;

select @sqlstr as 'selected';


No comments:

Post a Comment