combine multiple rows

• Bruna

  SSC Journeyman

  Points: 87

  More actions

  April 30, 2008 at 3:19 am

  #71248

  I have a SELECT:

  select client.id,service.id

  from cliente,service

  where cliente.id= service.id_cliente

  RESULT

  cliente.id service.id

  1 10

  1 20

  2 5

  2 1

  2 35

  3 6

  How can I get this RESULT:

  cliente.id service.id1 service.id2 service.id3

  1 10 20

  2 5 1 35

  3 6

  I dont know the maximum number of ServiceID's I can have per ClientID.

  Its dynamic.

• Mahesh Bote

  SSCrazy Eights

  Points: 9107

  More actions

  April 30, 2008 at 4:27 am

  #808901

  [font="Verdana"]Duplicate Post

  http://www.sqlservercentral.com/Forums/Topic492577-338-1.aspx[/font]

  MH-09-AM-8694