applying concat function on one column values to get data from another table

Question

table :

value  
- v1  
- v2

Now , I need to apply concat function on value col

concat(v1 , ' ' , v2)

like this.

I have used concat() on two or more col values but not on rows of one column.

How should I do it?

i tried string_agg on the col first and then try applying concat but that gives error as it will consider that as one value — sheetal verma, May 07 '19 at 06:31
Possible duplicate of [How FOR XML PATH('') works when concatenating rows](https://stackoverflow.com/questions/35148472/how-for-xml-path-works-when-concatenating-rows) — DhruvJoshi, May 07 '19 at 06:33
sample data : level new_value TRADING_COMPANY TRADING_COMPANY TRADING_COMPANY PRODUCT_RANGE result : concat (TRADING_COMPANY , ' ' , PRODUCT_RANGE) — sheetal verma, May 07 '19 at 06:35
tried this first :STRING_AGG(value, ' , ') as new_value but can't apply concat on new_value — sheetal verma, May 07 '19 at 06:36

score 0 · Answer 1 · answered May 31 '19 at 05:32

0

You may use STUFF for your solution.

 select stuff( (select ',' + column from table for xml path('')), 1,1,'')

answered May 31 '19 at 05:32

DarkRob

1 Answers1