重复行合并

[ttyrone]

select a.id,SpaceName from qrcodedoc a  left join QrCodeSpaceDetail g on a.id=g.QrCodeID  left join SpaceDoc h on g.SpaceCode=h.SpaceCode   where a.id='0004d24b-3ad6-4d56-8ebc-ba2f22cda6bb'

输出的结果是：
0004d24b-3ad6-4d56-8ebc-ba2f22cda6bb 客厅
0004d24b-3ad6-4d56-8ebc-ba2f22cda6bb 卧室

我想输出成
0004d24b-3ad6-4d56-8ebc-ba2f22cda6bb 客厅，卧室
请问应该怎么写

[二月十六]

不知道楼主的表结构，写了个小例子，楼主看一下：

--测试数据
if not object_id(N'Tempdb..#T') is null
	drop table #T
Go
Create table #T([id] uniqueidentifier,[SpaceName] nvarchar(22))
Insert #T
select N'0004d24b-3ad6-4d56-8ebc-ba2f22cda6bb',N'客厅' union all
select N'0004d24b-3ad6-4d56-8ebc-ba2f22cda6bb',N'卧室'
Go
--测试数据结束
SELECT  a.id ,
        STUFF(( SELECT  ',' + SpaceName
                FROM    #T b
                WHERE   a.id = b.id
              FOR
                XML PATH('')
              ), 1, 1, '') AS SpaceName
FROM    #T a
GROUP BY a.id

[学海无涯-回头是岸]

for XML PATH