Hi Team
I need some help, i have a query and want to write a sql server report that will do a check . If "Stock on Hand = 0" Then it must send a reminder to the recipient mail. That "Critical, Cyclical, Standard and Slow Movement".
SELECT InvWarehouse.StockCode, InvMaster.Description, InvWarehouse.Warehouse, InvWarehouse.QtyOnHand, InvWarehouse.QtyAllocated, InvWarehouse.QtyOnOrder, InvWarehouse.QtyInTransit, InvWarehouse.QtyOnBackOrder FROM sysproR.dbo.InvMaster InvMaster, sysproR.dbo.InvWarehouse InvWarehouse WHERE InvMaster.StockCode = InvWarehouse.StockCode