Warehouse Maintain...

Sp Update...


Add exectution type as well...

BEGIN
INSERT INTO [RD].[ProductWarehouse]
([BusinessUnit]
,[TerritoryCode]
,[WarehouseCode]
,[ProductCode]
,[ROL]
,[MinStock]
,[MaxStock]
,[EOQ]
,[ReorderMultiple]
,[LastStockTakeDate]
,[NoOfStockTakesPerYear]
,[DefaultLocationCode]
,[PrefSupplierCode]
,[CreatedBy]
,[CreatedOn]
,[ModifiedBy]
,[ModifiedOn])
VALUES
(@BusinessUnit
,@TerritoryCode
,@WarehouseCode
,@ProductCode
,@ROL
,@MinStock
,@MaxStock
,@EOQ
,@ReorderMultiple
,@LastStockTakeDate
,@NoOfStockTakesPerYear
,@DefaultLocationCode
,@PrefSupplierCode
,@CreatedBy
,getdate()
,@ModifiedBy
,getdate())
END

Read Users' Comments (1)comments