distinct comma separated values

• Oracle_91

  SSChampion

  Points: 14548

  More actions

  August 17, 2009 at 3:54 am

  #208815

  Hi Friends,

  Need small requirement

  CREATE TABLE MST_GENDER

  (YR INT,

  GENDER_DESC VARCHAR(100)

  )

  INSERT INTO MST_GENDER

  SELECT 2003,'M'

  UNION ALL

  SELECT 2003,'F'

  UNION ALL

  SELECT 2004,'M'

  UNION ALL

  SELECT 2004,'F'

  UNION ALL

  SELECT 2004,'O'

  -- NOW I WOULD LIKE TO ASSIGN DISTINCT VALUES OF GENDER IN A VARIABLE WITH COMMA SEPARTED

  -- ALL GENDERS

  DECLARE @values VARCHAR(500)

  SELECT @values = ISNULL(@values+',','')+GENDER_DESC FROM MST_GENDER

  SELECT @values

  --M,F,M,F,O

  i tried with the below but giving different output

  DECLARE @values VARCHAR(500)

  SELECT distinct @values = ISNULL(@values+',','')+GENDER_DESC FROM MST_GENDER

  SELECT @values

  -- O

  Thanks in Advance

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  August 17, 2009 at 3:58 am

  #1040066

  This should help you along

  http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/

  ---

  
  Clear Sky SQL
  My Blog[/url]

• arun.sas

  SSChampion

  Points: 11831

  More actions

  August 17, 2009 at 4:12 am

  #1040072

  hI,

  Also Try this

  DECLARE @values VARCHAR(500)

  SELECT @values = coalesce(@values+',','')+GENDER_DESC

  FROM MST_GENDER

  GROUP BY GENDER_DESC

  SELECT @values

• Oracle_91

  SSChampion

  Points: 14548

  More actions

  August 17, 2009 at 7:56 pm

  #1040602

  Hi Arun,

  Thank You.:-)