Hi everyone..
I've a stored procedure and procedure works well. In that procedure, there is one output parameter which i need to get returned.
this is my procedure..
ALTER PROCEDURE [dbo].[tgms_reclass_PO_bip](@po VARCHAR(20), @old_gl VARCHAR(20), @new_gl VARCHAR(20),@output varchar(500) out )
AS
IF (SELECT COUNT(*) FROM mm2po WHERE scode = @po) = 0
BEGIN
--SET @output = '1'
SET @output = 'Invalid PO Number'
END
/*****************************
Check if Old GL Code is valid
******************************/
IF (@output = ' AND (SELECT COUNT(*) FROM acct WHERE scode = REPLACE(@old_gl,'-',')) = 0)
BEGIN
--SET @output = '2'
SET @output = 'Invalid Old GL Account'
END
/*****************************
Check if New GL Code is valid
******************************/
IF (@output = ' AND (SELECT COUNT(*) FROM acct WHERE scode = REPLACE(@new_gl,'-',')) = 0)
BEGIN
--SET @output = '3'
SET @output = 'Invalid New GL Account'
END
/******************************************
Check if the PO has been invoiced or paid
************************
View Complete Post