关于字符串的链接
create table Test (barcode varchar(20),aa varchar(100))
go
insert into test
values('6900000000007','0.00(2),')
go
insert into test
values('6900000000007','8.00(2),')
go
insert into test
values('6900000000083','95.00(1),')
go
insert into test
values('6900000000083','86.20(1),')
go
select * from test
--------------
barcode aa
'6900000000007' 0.00(2),
'6900000000007' 8.00(2),
'6900000000083' 95.00(1),
'6900000000083' 86.20(1),
现在我想得到这样的结果：
barcode aa
'6900000000007' 0.00(2),8.00(2),
'6900000000083' 95.00(1),86.20(1),

也就是把barcode相同的aa连接起来。。我只想到了用游标的方式，可数据量很大，效率太低了。
有什么好的方法么？感谢~~
[解决办法]

create table Test (barcode varchar(20),aa varchar(100))
 go
 insert into test
 values('6900000000007','0.00(2),')
 go
 insert into test
 values('6900000000007','8.00(2),')
 go
 insert into test
 values('6900000000083','95.00(1),')
 go
 insert into test
 values('6900000000083','86.20(1),')
 go
 select barcode,
       aa=stuff((select ''+aa from test where barcode=a.barcode for xml path('')),1,1,'')
   from test a group by barcode
   
 /*
barcode              aa
-------------------- -----------------
6900000000007        0.00(2),8.00(2),
6900000000083        5.00(1),86.20(1),
   

[解决办法]
select barcode,(select aa+',' from test where barcode=a.barcode fro xml path('')) as aa
from test as a
group by barcode
[解决办法]

create table Test (barcode varchar(20),aa varchar(100))
 go
 insert into test
 values('6900000000007','0.00(2),')
 go
 insert into test
 values('6900000000007','8.00(2),')
 go
 insert into test
 values('6900000000083','95.00(1),')
 go
 insert into test
 values('6900000000083','86.20(1),')
 go


create function getstr(@id varchar(20))
returns varchar(100)
as
begin
     declare @str varchar(100)
     set @str=''
     select @str=@str+aa from Test where barcode=@id
     return @str
end
select barcode,dbo.getstr(barcode) from test group by barcode

/*
barcode              
-------------------- ------------------ 
 
6900000000007        0.00(2),8.00(2),
6900000000083        95.00(1),86.20(1),