SQL经典试题: 实现多条记录字串连接

1.问题描述：

数据库中有如下显示数据：

1400 Chan Ricky 
1400 Cheung Kirs 
1400 Ma Martin 
1500 Corporate Default Corporate Default 
1500 Kwan Tom 
1600 Mok Mary  

要求显示结果：
ACC_GROUP         PAYEENAMES 
1400                         Ma Martin/Cheung Kris/Chan Ricky 
1500                         Kwan Tom/Corporate Default Corporate Default 
1600                         Mok Mary

----------------------------------------------------------------------------------------------------------------------------------------------
问题回答：

create function Joe_get_str (@my_num int)
returns nvarchar(800)
as
begin
  Declare @mystr nvarchar(800)
  set @mystr =''
  select @mystr= @mystr + '/' + NOName from Table_sum where NONumber = @my_num
  set @mystr = substring(@mystr,2,800)
  return @mystr
end

select NONumber ,dbo.Joe_get_str(NONumber)
from
Table_sum
group by NONumber

3。关键语句：

--SQL查询记录结果为For变量可纵向相加:select @mystr= @mystr + '/' + NOName from Table_sum where NONumber = @my_num