Ok, i've searched through the forum archives and I came up with some results but nothing that seemed like it would work so, here we go.
I'm trying to send several results to multiple stored procs. here's a quick(syntactally incorrect) example:
select id from reps
where id in
(dbo.mystoredproc id,parameter2)
Essentially what i will be doing is nesting these here's another example:
(GetPastSeminars(mydate) ->
GetSeminarAttendance(seminar)->
UpdateAttendance(person)
I won't be getting that many results from my GetPastSeminars, 3 or 4 at most but GetSeminarAttendance will return between 10-40 records.
I'm kinda stuck here.