SQL Server Performance

rows to columns

Discussion in 'SQL Server 2005 General Developer Questions' started by joanne, Dec 6, 2010.

  1. joanne New Member

    Hello,
    I have a table with 2 columns:
    No SerialNumber
    123 4GB6Y78
    123 53F7TH
    124 4GB6Y78
    124 53F7TH
    124 53E8BX
    the question is :
    how to get the results as following:
    123 4GB6Y78 53F7TH
    124 4GB6Y78 53F7TH 53E8BX
    ...
    125 with 6 columns....
    etc...
    Thank you very much!
    joanne, Dec 6, 2010
    #2

  2. Luis Martin Moderator

    Check:
    http://sql-server-performance.com/Community/forums/p/10608/60651.aspx
    HTH
    Luis Martin, Dec 6, 2010
    #3

  3. FrankKalis Moderator

    Since you've posted this in the SQL Server 2005 forum, have a look at PIVOT() in the Books Online.
    FrankKalis, Dec 6, 2010
    #4

Share This Page