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','外包合計:')