I have a piece of dynamic SQL I need to execute, I then need to store the result into a variable.
I know I can use sp_executesql
but can't find clear examples around about how to do this.
dynamic-sqltsql
I have a piece of dynamic SQL I need to execute, I then need to store the result into a variable.
I know I can use sp_executesql
but can't find clear examples around about how to do this.
Best Answer
If you have OUTPUT parameters you can do
But if you don't, and can not modify the SP:
Not pretty, but works.