EXEC SP ‘procAlertGetOut’ WITH 2 params return

EXEC SP ‘procAlertGetOut’ WITH
‘@alerID’=SPParam.AlertId,’@alertName’=SPParam.AlertName OUT

What if I have to return 2 params from stored proc. How do I write that?

I believe you can have many input and output params. Just put an out after each one. Did you try that?

The only limitation is with the EXEC_SPF. It can only have 1 OUT

Bruce

That worked! Thank you.