We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
@ProdCode VARCHAR(10), @Qty INT, @RequestedBy VARCHAR(15), @Site VARCHAR(20), @WHouse VARCHAR(15), @Aisle VARCHAR(10), @Bay VARCHAR(10), @PallettNo VARCHAR(10), @InOut VARCHAR(5), @Comments VARCHAR(255) AS DECLARE @Rowcount INT SET NOCOUNT ON; INSERT INTO Warehouse.Movements (ProdCode, Qty, MoveDate, RequestedBy, [Site],WHouse,Aisle,Bay, PallettNo, InOut, Comments) VALUES(@ProdCode,@Qty,GETDATE(), @RequestedBy,@Site,@WHouse,@Aisle,@Bay, @PallettNo, @InOut,@Comments) UPDATE Warehouse.Products SET Warehouse.Products.Quantity = Warehouse.Products.Quantity + @Qty WHERE Warehouse.Products.ProdCode = @Prodcode UPDATE Warehouse.Locations SET Warehouse.Locations.Qty = Warehouse.Locations.Qty + @Qty WHERE ProdCode = @ProdCode AND [Site] = @Site AND WHouse = @WHouse AND Aisle = @Aisle AND Bay = @Bay AND PallettNo = @PallettNo
Join the community of 500,000 technology professionals and ask your questions.