I want to call a stored procedure within my main stored procedure to return a value.
Here is the code snippet: EXECUTE @ClaimNumber = [dbo].[uspGetNextNumber] 'BRP_INT' , 'ClaimHeader', 'ClaimNumber', 'dlivelsb'
When I run uspGetNextNumber by itself thru debugger, the proc returns the value. When I run the proc inside my stored procedure, it returns zero.
Any thoughts on why this is not working?
View Complete Post