--数据如下
DECLARE @t TABLE (pihao char(15),xpihao char(15))
INSERT @t SELECT '20100210',''
UNION ALL SELECT '20100305',''
UNION ALL SELECT '20100504',''
UNION ALL SELECT '20100506',''
UNION ALL SELECT '20100802',''
UNION ALL SELECT '20100805',''
UNION ALL SELECT '','20100305'
UNION ALL SELECT '','20100305'
UNION ALL SELECT '','20100802'
--数据示例
(9 行受影响)
pihao xpihao
--------------- ---------------
20100210
20100305
20100504
20100506
20100802
20100805
20100305
20100305
20100802
--麻烦将xpihao与pihao的重复值统计成如下格式(不用循环),谢谢
pihao
--------------
20100305,20100802
select @s=isnull(@s+',','')+rtrim(ltrim(pihao))
from @t t
where exists(select 1 from @t where xpihao=t.pihao) and pihao!=''
select @s