comma seperated result in a subquery

• ramadesai108

  SSChampion

  Points: 10609

  More actions

  August 3, 2010 at 3:07 pm

  #387494

  Hi All,

  I need to produce a comma seperated result in a subquery that way reducing the record count in the main query, how do I do that.

  example:

  SELECT field1, field2, field3

  FROM TABLEA

  because of field3, i end up with multiple records. But if i concatenate the values with commas of field3 into one subquery, then i will end up with unique records

  thanks.

• Ben Teraberry

  SSChampion

  Points: 11845

  More actions

  August 3, 2010 at 4:45 pm

  #1201844

  Take a look at this article[/url] (or many others out there) that describe how to use FOR XML PATH to concatenate values in a single column.

  └> bt
  

  ---

  
  Forum Etiquette: How to post data/code on a forum to get the best help[/url]

• ramadesai108

  SSChampion

  Points: 10609

  More actions

  August 4, 2010 at 9:00 am

  #1202132

  Hi BTerraberry,

  Thank you for your time, that really worked. Thanks again.