You have me at a disadvantage here. It seems you have some code that is already in use and some other that you are writing. The problem from my end is that I have no idea what is already in use, what the tables are, what procs you have in place etc. The reason I said SomeTable is because I have no idea where that data would come from.

If you already have a proc that you want to use you need to capture those details into a table.

I can give you an example of how you can capture the results of a stored proc into a temp table. Keep in mind that this assumes your proc ONLY returns a single result set. If it returns multiple result sets this becomes a bit more complicated.

First we need a stored proc.

create proc CaptureExample

as

select top 5 name, object_id, type, type_desc from sys.objects

This can represent your existing proc. Ignore that there is a top without an order by, this may very well return different results each time you run it (this is a topic for another day).

Now you want to capture those results into a table (a temp table in my example).

create table #MyCapture

(

name sysname,

object_id int,

type char(2),

type_desc nvarchar(60)

)

insert #MyCapture

exec CaptureExample

select * from #MyCapture

Does that help?