SQL中的数据合并

把中一列的数合并在一起，用逗号隔开
SELECT STUFF((SELECT '，'+AgencyName FROM ISSUE_AGENCY WHERE OrgID=t1.OrgID and IssueAgencyType='021001' FOR XML PATH('')), 1, 1, '') FROM ISSUE_AGENCY t1 where IssueAgencyType='021001' and OrgID='gssh0600444' GROUP BY OrgID,IssueAgencyType
SRUFF是SQL2005及以上版本提供的内置函数，如果是SQL2000可以自己写数据合并函数，如下：
GO
CREATE FUNCTION dbo.fnSRUFF (@OrgID varchar(50))
RETURNS varchar(8000)
AS
BEGIN
    DECLARE @AgencyName varchar(8000)    
    SELECT @AgencyName= Isnull(@values + ',', '') + AgencyName FROM ISSUE_AGENCY WHERE OrgID =@OrgID
    RETURN @AgencyName
END
GO