Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!
If @PickType = 'PickMan' Begin Update OrderDetail Set QtyPicked = @PickQty, Pickedby = @pUser, DatePicked = GETDATE ( ) Where OrderNo = @OrderNo and Barcode = @Bcode set @iMsg = 'Picked ordered qty for ' + @Bcode -- update the stock qty Update Stock Set StockQty = StockQty - isnull((@PickQty),0), QtyReserved = QtyReserved - isnull((@PickQty),0) Where Barcode = @Bcode goto ShowResults End
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.