Converting output of sql query

Question

Let say I have table

 Payments

Id int autoincement
Status int

and my query is :

select id, status from payments

but I wanna convert status to enum.

0 is unpaid
1 is paid.

so result should look like:

1 paid
2 unpaid
3 paid
...

I need this conversion because I use

XmlReader reader = cmd.ExecuteXmlReader();
oc.LoadXml("<results></results>");

XmlNode newNode = doc.ReadNode(reader);

while (newNode != null)
{
  doc.DocumentElement.AppendChild(newNode);
  newNode = doc.ReadNode(reader);
}

and then I save this xml and opening it by excel, and statuses should be friendly for user.

D'Arcy Rittich · Accepted Answer · 2010-05-10 17:00:58Z

4

select Id,
case status when 0 then 'unpaid' when 1 then 'paid' else 'unknown' end as Status
from Payments

answered May 10, 2010 at 17:00

D'Arcy Rittich

172k41 gold badges298 silver badges287 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Converting output of sql query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related