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