sql server 2005 下如何得出这样的结果？

[gooood]

2005的sqlServer！！！

数据：

A B C
1 a1 b2 c2
1 a2 b2 c3
2 a3 b1 c1
1 a8 b0 c3
2 a7 b2 c1
3 a1 b2 c2

得到：
1 a1b2c2\na2b2c3\na8b0c3
2 a3b1c1\na7b2c1
3 a1b2c2


谢谢

[点点星灯]

http://blog.csdn.net/zjcxc/archive/2006/06/09/784287.aspx
--参考

[鲁虾]

感觉没什么规律啊，！

[jacobsan]

写个自定义函数

[marco08]

--SQL2000
create table T(id int, A char(2), B char(2), C char(2))
insert T select 1, 'a1', 'b2', 'c2'
union all select 1, 'a2', 'b2', 'c3'
union all select 2, 'a3', 'b1', 'c1'
union all select 1, 'a8', 'b0', 'c3'
union all select 2, 'a7', 'b2', 'c1'
union all select 3, 'a1', 'b2', 'c2'

create function fun(@id int)
returns varchar(1000)
as
begin
declare @re varchar(1000)
set @re=''
select @re=@re+A+B+C+'\n' from T where id=@id

select @re=left(@re, len(@re)-2)
return @re
end

select distinct id, dbo.fun(id) from T

--result
id
----------- -------------------------------------------
1 a1b2c2\na2b2c3\na8b0c3
2 a3b1c1\na7b2c1
3 a1b2c2

(3 row(s) affected)

[marco08]

--SQL2005
參考http://community.csdn.net/Expert/topic/5208/5208517.xml?temp=.6628382

zlp321002(旅行) 的回複