建立暫時表

IF EXISTS(SELECT ID FROM TempDB..SYSOBJECTS WHERE ID=OBJECT_ID('TempDB..#MrpCyKnd')) drop table #MrpCyKnd

Create Table #MrpCyKnd ( KND VarChar(20) COLLATE database_default null ,

NAME VarChar(50) COLLATE database_default null)

delete from #MrpCyKnd

insert into #MrpCyKnd (KND,NAME) Values ('1','商品合計：')

insert into #MrpCyKnd (KND,NAME) Values ('2','製成品合計：')

insert into #MrpCyKnd (KND,NAME) Values ('3','半成品合計：')

insert into #MrpCyKnd (KND,NAME) Values ('4','原料合計：')

insert into #MrpCyKnd (KND,NAME) Values ('5','物料合計：')

insert into #MrpCyKnd (KND,NAME) Values ('6','下腳品合計：')

insert into #MrpCyKnd (KND,NAME) Values ('7','包裝物合計：')

insert into #MrpCyKnd (KND,NAME) Values ('A','人工合計：')

insert into #MrpCyKnd (KND,NAME) Values ('B','費用合計：')

insert into #MrpCyKnd (KND,NAME) Values ('C','外包合計：')