If you say you want to call a stored procedure in a select statement, will the stored procedure return only one value per call(row item returned by the select)? Saying that there won't be 1 to many, but 1 to 1.
If it is a 1 to 1 situation you could look at creating a function that can accept variables and pass back your result that you want and will do it per row returned in your select. Look at Create Function for a base understanding on functions.
answered Mar 09, 2016 at 10:47 AM