http://topic.csdn.net/u/20091006/15/4e5624a8-c975-4442-b470-7f0262e81268.html
当第3步也包含第一步的半成品，那么结果有点问题。（先把--select 15,4,'H-HP-WH2980',1 union all）注释，出来的数据没问题，不注释的时候就不对，麻烦看下。
Select * into SP_ProductP from (select 11 as ProductP_ID ,19 as ProductP_PID ,1 as ProductP_Order union all select 12,19,2 union all select 15,19,3 ) as aa
Select * into SP_ProductPItem from (
select 11 as ProductPI_PID ,2 as ProductPI_Type ,'BD0001' as ProductPI_MHNO,11 as ProductPI_UQty union all
select 11,2,'BD0003',20 union all
select 11,2,'BD0022',5 union all
select 12,2,'BD0005',3 union all
select 12,4,'H-HP-WH2980',2 union all
select 12,2,'BD0001',2 union all
--select 15,4,'H-HP-WH2980',1 union all
select 15,4,'H2-HP-WH2980',3 union all
select 15,2,'BD0008',5
) as bb
CREATE FUNCTION f_Bom(
@PID int
)RETURNS @t TABLE(ProductPI_PID int,ProductPI_Type int,ProductPI_MHNO varchar(20),ProductPI_UQty int,ProductP_Order int,Level int)
AS
BEGIN
DECLARE @Level int,@sRow int
SET @Level=1
Select @sRow =max(ProductP_Order) from SP_ProductP Where ProductP_PID =@PID
INSERT @t
select sub.ProductPI_PID
