Thursday 17 November 2011

Using CASE

update
    #temp
set
    esal =
case when esal >= 1000 or esal <= 2000 then esal + 1000
when esal >= 2000 or esal <= 5000 then esal + 2000
when esal >= 5000 or esal <= 10000 then esal + 3000
else
esal + 4000
end

No comments:

Post a Comment