SQL Merge Rows on Column

Question

I need a little help with a query I'm trying to run.

Basically I have two columns (trying to keep it simple) and I need to merge and concat These two columns are created from different tables with the following query:

select tmatter, tkinitb 
  FROM timecard, timekeep, matter
  where ttk = tkinit
  and mstatus = 'OP'
  group by tkinitb, tmatter
  order by tmatter ASC

tmatter  | tkinitb
1        |   A
1        |   B
2        |   C
2        |   D

I'm looking to have the results like this:

tmatter  | tkinitb
1        | A, B
2        | C, D

I'm not sure how to merge the different cells on the like cells.

Any help would be greatly appreciated.

looks like http://stackoverflow.com/questions/276927/can-i-concatenate-multiple-mysql-rows-into-one-field — TheBelgarion, Sep 15 '14 at 14:57

score 0 · Answer 1 · answered Sep 15 '14 at 14:57

0

select [Column  1],
       stuff((select ',' + [Column 2] from yourtable x where x.[Column 1] = t.[Column 1] for xml path('')), 1, 1, '')
from   yourtable t
group by [Column  1]

answered Sep 15 '14 at 14:57

Squirrel

23,507
4
34
32

I'm not sure why it's not working but every Column 2 contains every values, not sure those that match Column 1 – T.J. Sep 15 '14 at 15:16
can you show us the query that you used? – Squirrel Sep 17 '14 at 13:47

score 0 · Answer 2 · answered Sep 15 '14 at 15:05

0

SELECT  [COLUMN 1]
,STUFF( (SELECT  ',' + [COLUMN 2]
              FROM test T1
              WHERE T1.[column 1] = T2.[column 1]
              FOR XML PATH ('')
               ), 1, 1, '') 
FROM test T2
GROUP BY [column 1]

answered Sep 15 '14 at 15:05

radar

13,270
2
25
33

SQL Merge Rows on Column

2 Answers2