Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.
@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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.