Home Forums SQL Server 2005 SQL Server 2005 General Discussion Convert Columns to Row in SQL RE: Convert Columns to Row in SQL

  • December 16, 2013 at 7:18 am

    #1673675

    jeganbenitto.francis (12/16/2013)

    Can Anyone please help me in below requirement

    i have a row as below

    1 AAAA BBBB CCCC DDDD EEEE FFFF GGGG HHHH

    I want the output as follows

    AAAA BBBB CCCC DDDD

    EEEE

    FFFF

    GGGG

    HHHH

    But i dont want to use UNPIVOT..

    Thanks in advance

    the tool to use is the unpivot operator.

    if you don't want to use it, then you could try using a stack of unions:

    your fake data obscure the real issue a lot, hopefully this points you in the right direction.

    SELECT AAAA,BBBB,CCCC,DDDD As DDDD UNION ALL

    SELECT AAAA,BBBB,CCCC,EEEE As DDDD UNION ALL

    SELECT AAAA,BBBB,CCCC,FFFF As DDDD UNION ALL

    SELECT AAAA,BBBB,CCCC,GGGG As DDDD UNION ALL

    SELECT AAAA,BBBB,CCCC,HHHH As DDDD

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!