Home Forums SQL Server 2005 T-SQL (SS2K5) Clarity vs Speed RE: Clarity vs Speed
Antares686
SSC Guru
Points: 125444
More actions
October 26, 2007 at 2:44 pm
#745918
Actually I might do this personnally
SET @boo = (CASE
WHEN @gross_pay < 35.17 THEN 0
WHEN @gross_pay < 151 THEN 40
WHEN @gross_pay < 201 THEN 50
WHEN @gross_pay < 251 THEN 60
WHEN @gross_pay < 301 THEN 70
WHEN @gross_pay < 351 THEN 80
ELSE 90
END)