Jeetu .NET SQL
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment