ÇóSqlÓï¾ä?? - MS-SQL Server / »ù´¡Àà

tb_A
  TT_NO BillingTo
  T10-0001 ABC
  T10-0002 DEF

tb_B
  TT_NO ItemName 
  T10-0001 aaa
  T10-0001 bbb
  T10-0001 ccc
  T10-0002 a1
  T10-0002 hh

µÃµ½ÐÎʽ
tb_c
  TT_NO BillingTo ItemName 
  T10-0001 ABC aaa/bbb/ccc
  T10-0002 DEF a1/hh

---

×Ö·û´®ºÏ²¢ µÈÂ¥ÏÂ

---

ºÏ²¢×Ö·û´®

---

2000Óú¯Êý £¬2005ÓÃXML

---

SQL code:
/*
±êÌ⣺°´Ä³×ֶκϲ¢×Ö·û´®Ö®Ò»(¼òµ¥ºÏ²¢)
×÷Õߣº°®Ð¾õÂÞ.ع»ª(Ê®°ËÄê·çÓê,ÊصñùɽѩÁ«»¨¿ª)
ʱ¼ä£º2008-11-06
µØµã£º¹ã¶«ÉîÛÚ

ÃèÊö£º½«ÈçÏÂÐÎʽµÄÊý¾Ý°´id×ֶκϲ¢value×ֶΡ£
id value
----- ------
1 aa
1 bb
2 aaa
2 bbb
2 ccc
ÐèÒªµÃµ½½á¹û£º
id value
------ -----------
1 aa,bb
2 aaa,bbb,ccc
¼´£ºgroup by id, Çó value µÄºÍ£¨×Ö·û´®Ïà¼Ó£©
*/
--1¡¢sql2000ÖÐÖ»ÄÜÓÃ×Ô¶¨ÒåµÄº¯Êý½â¾ö
create table tb(id int, value varchar(10))
insert into tb values(1, 'aa')
insert into tb values(1, 'bb')
insert into tb values(2, 'aaa')
insert into tb values(2, 'bbb')
insert into tb values(2, 'ccc')
go

create function dbo.f_str(@id int) returns varchar(100)
as
begin
declare @str varchar(1000)
set @str =