Why the Output parameter did not work?

Question

Suppose I have table with columns: ID, Group Number, Value. Want the SP code output the Max value of specific Group Number and then use this max value in further query.

Tried this:

CREATE PROC SP_TestOutput
@GroupNum int,
@max_value int Output
AS
Select @max_value = MAX(val)
From mytable
Where GroupNum = @GroupNum

EXEC SP_TestOutput  @GroupNum=1001

Select ID
From mytable Where Col2 = @max_value

Please help, thanks in advance.

Answer 1

Hi @Siver

You need another parameter to receive the output value in the Execute clause.

Try this:

EXEC SP_TestOutput  @GroupNum=1001 , @max_value=@max_value_final OUTPUT
Select ID
From mytable Where Col2 = @max_value_final

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.