return select from dynamic sql

[szlamany]

Good point - if you are getting an error (like you might be doing a SUM() and you have NULL's in the field you are summing) that error message might get "in front of the return data" when called from code.

I always create my SPROCS in a QUERY WINDOW - usually with an EXECUTE of that SPROC at the bottom to test it.

Then I save my CREATE SPROC as a .SQL text file...