Hi there,
I am trying to return some data in Transact SQL. The small example table below shows the core data and the Example OutPut shows what I am trying to achieve. I want one row per Client however I cant think of a way to do this. Any ideas anyone.
Example Date
ClientNo SystemID Facility
0000002/001 0000002 Payments
0000002/001 0000002 Cheques
0000002/001 0000002 CHAPS
0000002/001 0000002 BACS
0000002/001 0000002 Cash
OutPut Data
SystemID Facility
0000002 Payments,Cheques,CHAPS,BACS,Cash
I am trying to return some data in Transact SQL. The small example table below shows the core data and the Example OutPut shows what I am trying to achieve. I want one row per Client however I cant think of a way to do this. Any ideas anyone.
Example Date
ClientNo SystemID Facility
0000002/001 0000002 Payments
0000002/001 0000002 Cheques
0000002/001 0000002 CHAPS
0000002/001 0000002 BACS
0000002/001 0000002 Cash
OutPut Data
SystemID Facility
0000002 Payments,Cheques,CHAPS,BACS,Cash