Combining multiple columns into one- SQL Server 2008

Question

I am trying to make one table value function in Sql Server. Here I have 3 columns and i want to merge them into one column lets say "new". This new column should show the name of 3 columns if they have value as 1.For example for row one it should display Isprod, for row 2 it should display IsCompetProd and so on.

 IsProd IsCompetProd       IsOther
    1            0             0
    0            1             0
    0            0             1
    1            0             0

Is there any way to do that?

What have you tried so far? Please post your code in your question by editing it. — shree.pat18
– shree.pat18, Commented Mar 25, 2014 at 7:15
@shree.pat18 actually i searched it but couldn't figure out how to start it.. — user3201916
– user3201916, Commented Mar 25, 2014 at 7:19

Vignesh Kumar A · Accepted Answer · 2014-03-25 07:24:33Z

1

Try like this

SELECT CASE WHEN IsProd=1 THEN 'IsProd'
            WHEN IsCompetProd=1 THEN 'IsCompetProd'
            WHEN IsOther=1  THEN 'IsOther'
        END [New]
FROM table1

answered Mar 25, 2014 at 7:24

Vignesh Kumar A

28.6k14 gold badges67 silver badges119 bronze badges

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

Comments

Arion · Accepted Answer · 2014-03-25 07:19:20Z

1

If I am getting what you want. Use a case statement. Try this:

SELECT
    tbl.*,
    (
    CASE 
        WHEN IsProd=1
        THEN 'IsProd'
        WHEN IsCompetProd=1
        THEN 'IsCompetProd'
        WHEN IsOther=1
        THEN 'IsOther'
        ELSE 'None'
    END 
    )AS newColumn       
FROM
    tbl

answered Mar 25, 2014 at 7:19

Arion

31.3k10 gold badges74 silver badges89 bronze badges

Collectives™ on Stack Overflow

Combining multiple columns into one- SQL Server 2008

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related