Home Forums SQL Server 2008 SQL Server 2008 - General Case statement in the where condition RE: Case statement in the where condition
TomThomson
SSC Guru
Points: 104773
More actions
September 16, 2014 at 5:34 pm
#1745935
where @parameter = 'All'
or (@parameter = 'GT30' and updated_date < getdate() - 30)
or (@parameter = 'LT30' and updated_date between getdate()-30 and getdate()) ;
Tom