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 8, 2014 at 11:36 am

    #1704232

    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

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day