Viewing 2 posts - 1 through 2 (of 2 total)
select * from dbo.tablename where empname=case when @strempname='' then empname else @strempname end
July 18, 2012 at 12:46 am
#1514016
select * from dbo.table where empname=case when @strempname='' then empname else @strempname end
July 18, 2012 at 12:42 am
#1514015