一個比較牛的預存程序

今天同事說得：
create table tblTest
(
PdID int,
PdName varchar(100)
)
insert tblTest
select 1, 'A10' union all
select 2, 'A20,A20S' union all
select 3,       'A30,A30K,A30M' union all
select 4, 'A301' union all
select 5, 'A301M'
go

-- 建立一個輔助的暫存資料表就可以了
SELECT TOP 8000
 id = identity(int,1,1)
INTO # FROM syscolumns a, syscolumns b

SELECT A.PdID, PdName = SUBSTRING(A.PdName, B.ID, CHARINDEX(',', A.PdName + ',', B.ID) - B.ID)
FROM tblTest A, # B
WHERE SUBSTRING(',' + a.PdName, B.id, 1) = ','
GO

DROP TABLE tblTest, #