Cama saperated values

• kbhanu15

  SSCarpal Tunnel

  Points: 4498

  More actions

  December 30, 2022 at 2:04 pm

  #4131900

  Hi,

  this is my Query.

  create table #emp(  sal int)

  insert into #emp(sal)

  values (1000),(2000),(3000),(5000)

  select * from #emp

  data:

  1000

  2000

  3000

  4000

  exptext output ::

  1000,2000,3000,5000

   

   

• Jeff Moden

  SSC Guru

  Points: 1004581

  More actions

  December 30, 2022 at 4:15 pm

  #4131951

  Here's the solution to the problem you posted.

   SELECT CSV = STRING_AGG(sal,',')
     FROM #emp
  ;

  There are more powerful uses for the STRING_AGG() function if you have a look at the MS Doc on the subject.

  https://learn.microsoft.com/en-us/sql/t-sql/functions/string-agg-transact-sql

   

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• kbhanu15

  SSCarpal Tunnel

  Points: 4498

  More actions

  January 3, 2023 at 9:05 am

  #4132947

  thank you

• January 6, 2023 at 6:26 am

  This was removed by the editor as SPAM