id name date
--------------------
1 a 2007-1-7
1 b 2007-1-2
3 c 2007-1-3
2 d 2007-1-4
1 e 2007-1-5
2 f 2007-1-6要求这样的结果, SQL语句该怎么写?
id name
-------------
1 b,e,a
2 d,f
3 c
--------------------
1 a 2007-1-7
1 b 2007-1-2
3 c 2007-1-3
2 d 2007-1-4
1 e 2007-1-5
2 f 2007-1-6要求这样的结果, SQL语句该怎么写?
id name
-------------
1 b,e,a
2 d,f
3 c
returns varchar(100)
as
begin
declare @sql varchar(1000)
select @sql=isnull(@sql+',','')+name from [Table] where id=@id order by date
return @sql
end
go
select id,dbo.fn_test(id) from [Table] group by id