select * from A where (1=1) and case @hour when 72 then Isemailsend72 = 0 else IsEmailsend72=1 end
select * from A where (1=1) and Isemailsend72 = case when @hour = 72 then 0 else 1 end
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)