Home Forums SQL Server 2008 SQL Server Newbies Concatenating rows from aliased tables on MSSQL 2005 server RE: Concatenating rows from aliased tables on MSSQL 2005 server

  • domingo.sqlservercentral (3/26/2014)


    ... and I need this rows concatenated as below:

    2014-03-25 12:31:00.000StationIDAnnie LennoxDave StewartEurythmicsDave StewartEMI1IDshortinfo

    2014-03-25 13:33:00.000TrafficBob Dylan, Louis ArmstrongPaul McCartney, Bob DylanGlenn Miller, Pet Shop BoysWarner2TRAFFICshortinfo

    2014-03-25 14:38:00.000CarpetPaul McCartney, Bob Dylan, Mike RutherfordPaul McCartney, Bob Dylan, Mike RutherfordQueen, The Beatles, GenesisFreddie MercuryUniversal3CARPETshortinfo

    2014-03-25 15:41:00.000StationIDAnnie LennoxDave StewartEurythmicsDave StewartEMI1IDshortinfo

    2014-03-25 16:45:00.000TrafficBob Dylan, Louis ArmstrongPaul McCartney, Bob DylanGlenn Miller, Pet Shop BoysWarner2TRAFFICshortinfo

    am interested in what you intend to do with your output above...I don't see any determining column to distinguish authors from composers from performers etc....???

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