Returning rows with a stored procedure
Posted on 2012-03-22
I hope somebody can help me with the following.
I need to retrieve some records using a SELECT but also using a stored procedure.
Suppose the table (myTable) I have has the following format:
ID NAME DOB SCORE
I have a stored procedure myStoredProcedure(NAME, X, Y, Z)
where NAME and SCORE are values passed in and X, Y and Z are returned values.
This is the pseudo code I'm trying to do
SELECT * FROM myTable WHERE myTable.SCORE = X "using" myStoredProcedure(myTable.NAME, X, Y, Z)
where X is an output parameter from the stored procedure using values from myTable.
Can anybody help?
Thanks in advance