I am a newly indoctrinated SQL Server 2005 user. So, forgive me if this
question is amatuer.
I am trying to create a stored proc that will read in a list of values
from one table (Possibly using a cte?) then iterate through each record
running another sp to populate a temp table and return all matching
records. The logic would be like the following:

///////
create procedure spSample1

@column2 int

As

create table #tmptbl

(tmptblcol1 int not null)

with samplecte (var1 int)
As
(select column1 from table where column2 = @column2)
begin
while not end-of-file

set localvar1 = current value of samplecte var1

insert into #tmptbl exec spSample2 localvar1
end
////////

This is a very rough outline. Hopefully it helps with clarification of
what I am trying to acheive. Any help would be greatly appreciated.

Thank you in advance!

rbr

rbr wrote:
<snip>

It's not clear to me what your question is, but you might have better
luck getting technical assistance in the
microsoft.public.sqlserver.programming news group.

Bob Lanteigne

"rbr" <ryankbrown (AT) gmail (DOT) com> wrote

Your question is not clear, but I think that you must use a cursor and fetch
one by one record from your table.
Try to see in help sintax for cursor. I think this might be usefull for you.
Sorry, I dont have enough time to explain complete solution or to write
code.

Bye.