sql2005中 outer apply的使用
SELECT * FROM (SELECT DISTINCT id,address,phone FROM tbinfo) A OUTER APPLY(
SELECT [values]= STUFF(REPLACE(REPLACE(
(
SELECT value FROM tbinfo N
WHERE id = A.id
FOR XML AUTO
), '<N value="',','), '"/>',''), 1, 1,'')
)N
SELECT [values]= STUFF(REPLACE(REPLACE(
(
SELECT value FROM tbinfo N
WHERE id = A.id
FOR XML AUTO
), '<N value="',','), '"/>',''), 1, 1,'')
)N