日期:2014-05-17 浏览次数:20397 次
CREATE TABLE #tb(standards varchar(50), amount varchar(50), variation varchar(50),statuss varchar(50),fee money,Reason varchar(500))
go
insert into #tb values('55','279',4,'物量积压',200,'加工人员设备不足;T排制作进度较慢;')
insert into #tb values('55','279',4,'物量积压',400,'部件人员不足;')
insert into #tb values('55','279',4,'物量积压',600,'跨间场地积压;图纸问题较多;')
insert into #tb values('56','300',4,'物量积压',700,'AAAA;')
insert into #tb values('56','300',4,'物量积压',800,'BBBB;')
insert into #tb values('56','300',4,'物量积压',400,'CCCC;')
GO