Group Values in TSQL

• Conficker

  SSCommitted

  Points: 1567

  More actions

  November 8, 2012 at 3:30 am

  #269976

  Hello,

  How can i merge same fields different values to one value?

  eg. tblEmployee table and output is,

  Date Employee Summary

  07/11/2012 Susan Job 1 Done

  07/11/2012 Susan Job 2 Done

  07/11/2012 Mike Job 11 Done

  07/11/2012 Mike Job 12 Done

  Desire Output:

  Date Employee Summary

  07/11/2012 Susan Job 1 Done and Job 2 Done

  07/11/2012 Mike Job 11 Done and Job 12 Done

• Eugene Elutin

  SSC Guru

  Points: 59322

  More actions

  November 8, 2012 at 3:48 am

  #1557081

  google:

  T-SQL concatenate string FOR XML PATH

  _____________________________________________
  "The only true wisdom is in knowing you know nothing"
  "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
  (So many miracle inventions provided by MS to us...)

  How to post your question to get the best and quick help[/url]

• kiril.lazarov.77

  Hall of Fame

  Points: 3742

  More actions

  November 8, 2012 at 3:48 am

  #1557082

  No EmployeeId? Why? You might have two employees with the same name..

  SELECT DISTINCT

  EmployeeId ,

  Date ,

  Employee ,

  STUFF(( SELECT ' and ' + t2.Summary AS [text()]

  FROM tblEmployee t2

  WHERE t2.EmployeeId = t1.EmployeeId

  FOR

  XML PATH('')

  ), 1, 5, '') AS Summary

  FROM tblEmployee t1

• Conficker

  SSCommitted

  Points: 1567

  More actions

  November 8, 2012 at 4:03 am

  #1557086

  You are Super Star clayman, make my day

  There is EmployeeID, it was just example and in a rush didn't define.

  Thanks Again.