SELECT a1,
STUFF((SELECT ','+b2 FROM 表b B
WHERE','+A.a2+','LIKE'%,'+b1+',%' FOR XML PATH('')),1,1,'')a2
FROM 表a A
STUFF((SELECT ','+b2 FROM 表b B
WHERE','+A.a2+','LIKE'%,'+b1+',%' FOR XML PATH('')),1,1,'')a2
FROM 表a A
STUFF((SELECT ','+b2 FROM 表b B
WHERE','+A.a2+','LIKE'%,'+CAST(b1 AS VARCHAR(10))+',%' FOR XML PATH('')),1,1,'')a2
FROM 表a A
哪为高手帮我写个函数?
http://www.cnblogs.com/chillsrc/archive/2011/03/02/1969010.html