Distinct Row - Multiple Values

• Michelle-164472

  SSCommitted

  Points: 1715

  More actions

  November 12, 2004 at 1:38 pm

  #84102

  First of all, sorry for the DOUBLE post...I was in the WRONG forum

  Hi All,

  I have a query where I need to ONE row for each say Prod_Id...however there are multiple Assignees with the same Prod_Id...is there a way to produce a result set like this:

  1, (jackie, luke, alice), 34, tester, 68, GO

  Prod_id, Assignees, ALL other columns are the same...

  1, Jackie, 34, tester, 68, GO

  1, Luke, 34, tester, 68, GO

  1, Alice, 34, tester, 68, GO

  I've tried Distinct, Having and so on...still getting the multiple rows...I am joining tables to acquire the "Assignees" name...

  Thanks...

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  November 12, 2004 at 2:26 pm

  #530017

  Okay, then we should leave this thread alive.

  Still I think, posting your table structure(s) makes things a lot easier.

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]