Select and set in column

Question

I got a simple select case with where condition, where Conditions are different values.
How Can I put those condition values into columns.
For exemple:

select fld1, fld, fld3 from tbl where val in (13, 14, 17)

I want to display those data in table configured like:

fld1| fld2|fld3| 13| 14| 17|
12    12   23   val val val

Answer 1

0

Would this do it or have I completely missed the point.

   SELECT
          fld1, fld2, fld3,
          CASE WHEN val = 13 THEN val ELSE 0 END AS [13],
          CASE WHEN val = 14 THEN val ELSE 0 END AS [14],
          CASE WHEN val = 17 THEN val ELSE 0 END AS [17]


          FROM #Temp AS T

answered Jun 09 '11 at 08:08 AM

Mrs_Fatherjack
4.6k ● 44 ● 53 ● 60

Works good... Thank you

Jun 09 '11 at 11:22 PM Gogolo

(comments are locked)

Select and set in column

Follow this question

Related Questions