ÇóSQLÓï¾ä¡£

±ípartInfo
ID partType
--------------------------
pt001 A1
pt001 A1/A2
pt002 B1
pt002 B2
-------------------------
ÒªÇó½á¹û
ID partType
--------------------------
pt001 A1/A2
pt002 B1/B2

---

¸ø¸ö˵Ã÷»ò·½·¨,½á¹ûÔõôÀ´µÄ?

---

create function f_str(@id varchar(10))
returns varchar(1000)
as
begin
  declare @s varchar(1000)
  select @s = isnull(@s+'/','')+case when charindex('/'+parttype+'/','/'+@s+'/')>0 then '' else parttype end from partinfo where id = @id
  return @s
end
go

select id,dbo.f_str(id)
from from partinfo 
group by id

---

ÒýÓÃ

create function f_str(@id varchar(10))
returns varchar(1000)
as
begin
declare @s varchar(1000)
select @s = isnull(@s+'/','')+case when charindex('/'+parttype+'/','/'+@s+'/')>0 then '' else pa¡­¡­

ËÙ¶ÈÌ«¿ìÁË

---

²»ÐУ¬»¹ÊÇÏÈÕÛ·Ö

---

SQL code:
----------------------------------------------------------------
-- Author :fredrickhu(СF£¬Ïò¸ßÊÖѧϰ)
-- Date :2010-04-02 16:47:45
-- Verstion:
-- Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86)