Home Forums SQL Server 2008 SQL Server 2008 - General Case statement with <> condition RE: Case statement with <> condition
Megha P
SSCommitted
Points: 1976
More actions
May 8, 2014 at 12:24 am
#1711758
Sean Lange's code works perfectly ..with index seek
WHERE (@p_flag = 1 AND moveFlag = 26)
OR (@p_flag <> 1 --if this is a bit I would use = 0 instead of <> 1
AND moveFlag > 26 OR moveFlag < 26)
Thank you all...