Haven't seen such a scenerio and would like to know if its pooisble to use store prcedure in a SQL statement?
Please share any insight !!
You can call Store procedure as a block of program.
If you want call them in a SQL statement, try Function, try SQL UDF.