i want a different output in my t-sql query

• marionoronha.s

  Grasshopper

  Points: 20

  More actions

  June 16, 2010 at 11:11 pm

  #223910

  hi ,

  i have tow tables in my sql server database with the schema as follows :

  t_Client table

  ClientID int

  ClientNamevarchar(100)

  TitleID int

  Email varchar(100)

  Descriptionvarchar(500)

  Location varchar(100)

  Tenure int

  username varchar(200)

  password varchar(200)

  SurveyID int

  t_Clinent_Process Table

  Client_ProcessIDint

  ClientID int

  ProcessIDint

  SurveyID int

  Respondedbit

  now i have query which queries the above table and gives the following result ouput as below.

  

  now in the above output i Mario Morkel with client id 474 is repeated twice because he is aligned to two processes now i would want the output in such a way so that the row for client id should appear only once as follows :

  ClientID SurveyID ClientName ProcessName ProcessID

  474106Mario Morkel TestProcess1,TestProcess2 386

  so i want the process name to appear seperated by commas instead of two different rows

  thanks

  Mario Noronha

• malleswarareddy_m

  SSCertifiable

  Points: 5847

  More actions

  June 16, 2010 at 11:24 pm

  #1181362

  Hi,here i am unable to see your picture.

  this topic is similar to my thread.

  Please go through the thread you will find the answer.

  http://www.sqlservercentral.com/Forums/Topic922837-338-1.aspx

  Malleswarareddy
  I.T.Analyst
  MCITP(70-451)

• marionoronha.s

  Grasshopper

  Points: 20

  More actions

  June 17, 2010 at 12:18 am

  #1181376

  thanks maleswar i have got the answer from the thread you told me