Tuesday 6 September 2011

Case Example in SQL SERVER

case LEAD.flag when '1' then 'Deposited'
when '0' then 'Advisor'
when '2' then 'Login'
when '3' then 'N/I'
end [flag],

case Lead.Life_MF
when 'M' then 'Mutual Fund'
else
'Life Insurance'
end
as MF_Life

No comments:

Post a Comment