How to use a value from one stored procedure in another?
- by RoguePlanetoid
I have the following statement in a Stored Procedure:
DECLARE @Count INT
EXEC @Count = GetItemCount 123
SELECT @Count
Which calls another stored procedure with the following statement inside:
SELECT COUNT(Item) FROM tblItem WHERE ID = @ID
However when I test the call the EXEC outputs the value correctly but it
is not assigned to the @Count…