create table test_c ( a int, b varchar(10), c varchar(10))
go
insert test_c values (1,'22','ss')
insert test_c values (2,'23','s4rs')
insert test_c values (1,'22s','sss')
insert test_c values (1,'s232','sswq')
insert test_c values (2,'2gf2','sss')
insert test_c values (3,'sa22','sss')
insert test_c values (3,'2z2','asss')
go
create function func_c ( @a int) returns varchar(4000)
as
begin
declare @str varchar(4000)
select @str = ''
select @str = @str + b + ',' + c + ',' from test_c where a =@a
return @str
end
goselect a ,dbo.func_c(a) from test_c group by a
go
insert test_c values (1,'22','ss')
insert test_c values (2,'23','s4rs')
insert test_c values (1,'22s','sss')
insert test_c values (1,'s232','sswq')
insert test_c values (2,'2gf2','sss')
insert test_c values (3,'sa22','sss')
insert test_c values (3,'2z2','asss')
go
create function func_c ( @a int) returns varchar(4000)
as
begin
declare @str varchar(4000)
select @str = ''
select @str = @str + b + ',' + c + ',' from test_c where a =@a
return @str
end
goselect a ,dbo.func_c(a) from test_c group by a
http://expert.csdn.net/Expert/topic/632/632928.xml?temp=.1936914