SQL 记录字段合并

select MessageID, MuiltColumnID = stuff((select ',' + CAST (ColumnID as varchar) from MessageColumn t where MessageID = MessageColumn.MessageID for xml path('')) , 1 , 1 , '')
from MessageColumn
group by MessageID
having count(*)>1
posted @ 2009-10-23 16:39  heshangwen  阅读(62)  评论(0)  编辑  收藏  举报