我有一张有狭窄的桌子如下:
Ticket Comment UpdatedBy
100 Text 1 23
100 Text 2 24
100 Text 3 25
100 Text 4 26我可以把它放在一个行表中作为(所有行的票证都一样)
Ticket Comment
100 23 Said Text 1 - 24 Said Text 2 - 25 Said Text 3 - 26 Said Text 4由某些SQL查询?( Server 2008)
发布于 2012-11-20 10:30:23
您可以使用FOR XML PATH
SELECT Ticket,
STUFF((SELECT distinct ' - ' + cast(UpdatedBy as varchar(20)) + ' ' + comment
from yourtable t2
where t1.Ticket = t2.Ticket
FOR XML PATH(''), TYPE
).value('.', 'NVARCHAR(MAX)')
,1,2,'') comments
from yourtable t1
group by ticket请参阅与Demo
结果:
| TICKET | COMMENTS |
-----------------------------------------------------------
| 100 | 23 Text 1 - 24 Text 2 - 25 Text 3 - 26 Text 4 |发布于 2012-11-20 10:47:35
你可以这样做:
SELECT ticketno
, STUFF((SELECT ' - ' + CAST(updateby AS VARCHAR) + ' said ' + comment
FROM tickets
WHERE (ticketno = t.ticketno)
FOR XML PATH ('')
),1,3,'') AS Comments
FROM tickets t
GROUP BY ticketnohttps://stackoverflow.com/questions/13471159
复制相似问题