create table a(
id char(10),
avalue varchar(10)
)
go
create table a(
id int,
aid char(10),
name varchar(10),
value varchar(40)
)
go
create function getstr(@id char(10))
returns Nvarchar(2000)
as
begin
declare @str Nvarchar(2000)
set @str=N''
select @str=@str+N','+rtrim(Name) from b
where aid=@id
order by id