Link to home
Start Free TrialLog in
Avatar of dbrennecke
dbrennecke

asked on

Calling stored procedure from a select statement

I need to call a stored prcedure from a select statement, but can't seem to get the syntax correct.

the SP accepts 2 input parameters, and outputs 1.

so how would I do it?
SELECT
<other stuff>,
my SP call returning an element,
<other stuff>
from...
where...
ASKER CERTIFIED SOLUTION
Avatar of chapmandew
chapmandew
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dbrennecke
dbrennecke

ASKER

rrrrrrrrrrrrrrrrrrrrgh
I turned it into a function since I was only returning one element....