How can I write this stored procedure that would check stockqty and print message if it goes down to zero? Currently I am getting error. Thanks.
Error:
Msg 102, Level 15, State 1, Procedure ValidateQty, Line 8
Incorrect syntax near ';'.
Msg 137, Level 15, State 2, Line 3
Must declare the scalar variable "@vStockqty".
Msg 137, Level 15, State 2, Line 5
Must declare the scalar variable "@Partid".
Msg 137, Level 15, State 2, Line 8
Must declare the scalar variable "@vStockqty".
Msg 137, Level 15, State 2, Line 9
Must declare the scalar variable "@Partid".
--------------------------------------------------------------------------------
IF EXISTS (SELECT name FROM SYSOBJECTS WHERE name = 'ValidateQty')
BEGIN DROP PROCEDURE ValidateQty; END;
GO
CREATE PROCEDURE ValidateQty
@vStockqty CHAR(10),
@Partid CHAR(10)
AS
BEGIN
END;
GO
IF (@vStockqty < 1 (SELECT Stockqty
FROM Inventory
WHERE PartID = @Partid) )
BEGIN
EXECUTE ValidateQty 0, @vStockqty;
PRINT 'Stock quantity is below zero for ' + @Partid ;
END;
GO