Home Forums SQL Server 2005 T-SQL (SS2K5) Convert Row Data in 1 Field to Many Columns RE: Convert Row Data in 1 Field to Many Columns

  • April 9, 2014 at 6:34 am

    #1704473

    J Livingston SQL (4/8/2014)

    Japster (4/2/2014)

    What I want is

    SerialBox SerialNo1 SerialNo2 SerialNo3 SerialNo4 SerialNo5 SerialNo6 SerialNo7

    Box1 Serial1 Serial2 Serial3 Serial4 Serial5 Serial6 Serial7

    Box2 Serial1 Serial2 Serial3 Serial4 Serial5 Serial6 Serial7

    Box3 Serial1 Serial2 Serial3 Serial4 Serial5 Serial6 Serial7

    Can this be done in a View ?

    Thanks,

    Craig

    were you expecting that each serialno was in a separate column?

    am thinking you made to need to use dynamic SQL

    Yes was expecting the SerialNo's to be in seperate columns. I did post it that way in the original post but it's stripped out the spaces and squished it up

    Thanks