To fetch values from a column using Case statement

Posted by Anishabathija under Sql Server on 4/15/2014 | Points: 10 | Views : 1186 | Status : [Member] | Replies : 3

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

I have a column status which can have three possible values 0,1 and 2.

I am writing a Stored procedure and I'm fetching the values from this column and writing into a new column called progstatus using a case statement.

The condition is when it is 1 it should show active and when 0 then inactive.
however, the records with status 2 should not be fetched.

Now I have written a condition such as

Case [Status] when 0 then 'InActive' when 1 then 'Active' End as ProgStatus,

However records with status 2 is getting value "NULL".. please help modify the case statement.

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Vuyiswamb on: 4/15/2014 [Member] [MVP] [Administrator] NotApplicable | Points: 25

0	Then extend it like this Case ISNULL([Status],0) when 0 then 'InActive' when 1 then 'Active' Thank you for posting at Dotnetfunda [Administrator] Anishabathija, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Markconroy on: 7/28/2015 [Member] Starter | Points: 25

0	Case ISNULL([Status],0) when 0 then 'InActive' when 1 then 'Active' This will really help you... Anishabathija, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Jayakumars on: 7/29/2015 [Member] [MVP] Bronze | Points: 25

0	Hi both answer not working try this sample code declare @status int=0 Select Case ISNULL(@status,0) when 0 then 'InActive' when 1 then 'Active' END as Status declare @status int=1 Select Case ISNULL(@status,0) when 0 then 'InActive' when 1 then 'Active' END as Status Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Anishabathija, if this helps please login to Mark As Answer. \| Alert Moderator

Hi
both answer not working

try this sample code

declare @status int=0
Select Case ISNULL(@status,0)
when 0 then 'InActive'
when 1 then 'Active' END as Status

declare @status int=1
Select Case ISNULL(@status,0)
when 0 then 'InActive'
when 1 then 'Active' END as Status

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com

Anishabathija, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts