Joshua Olson wrote: >Try: > >declare DNCList cursor for > SELECT job AS 'joblist' > FROM jobs > WHERE --etc > >OPEN DNCList > FETCH NEXT FROM DNCList into @joblist > while @@fetch_status = 0 > begin > set @query = 'SELECT * FROM ' + @joblist --etc > exec(@query) > FETCH NEXT FROM DNCList into @joblist > end > > CLOSE DNCList >DEALLOCATE DNCList > > Josh, et all - thanks for the responses. Fortunately, this was solved a couple days ago... must've got clogged in the pipes. What I ended up doing was creating a union statement, to union all the inner selects, and then finally exec() the created querystring. The orig. code worked fine in query analizer, but since the produced out put was a series of selects (like writing: select * from table1 select * from table2 and firing them off at the same time-- you get the two seperate results sets, thus, the recordset was only pulling the first select. Unioned them all together, then fired it off, and things seem to work as desired. But thanks. perhaps moving the exec() inside is better than unioning them together. I'll have to try this tomorrow at the office.