All replies

There are several ways to accomplish what you are trying to do. A key question associated with this is whether or not the intended procedure updates anything. Please comment on this. Methods to accomplish what you want include:

Using INSERT INTO table EXECUTE procedure and then using the table for JOIN purposes -- typically a temp table or a table varable (if using SQL 2005) is used for this

You might want to consider converting your procedure to a function -- especially an inline function -- if possible. (This is not possible if the procedure updates anything)

You might be able to use the OPENROWSET function to encapsulate the procedure. (This will work even if the procedure does any updates; however, under these circumstances this idea becomes nasty)