数据库命令

导入初期库存

delete mms_Inventory_Label_Print

INSERT INTO mms_Inventory_Label_Print (ID,WAREHOUSE,MATERIAL_NO, QTY)
SELECT (select newid()) as ID,仓库, 料号,QTY
FROM 工作表1
where QTY <> '0.0'


update [Udit.Mms].[dbo].[mms_Inventory_Label_Print] set [WAREHOUSE]='R01'
where [WAREHOUSE]='材料仓'

INSERT INTO mms_Inventory_Label_Print (ID,WAREHOUSE,MATERIAL_NO, QTY,[DATECODE],[ExtendChar05])
SELECT (select newid()) as ID,仓库, 料号,现存量,FORMAT([最近异动日期], 'yyyyMMdd') as DC,FORMAT([最近异动日期], 'yyyyMMdd') as EX5
FROM 一年以上无需求物料明细

INSERT INTO mms_Inventory_Label_Print (ID,WAREHOUSE,MATERIAL_NO, QTY,[DATECODE],[ExtendChar05])
SELECT (select newid()) as ID,'R01', lh,sl,'2024-08-04', '2025-02-04'
FROM [Udit.CSR].[dbo].[kc0804_20]