Hmmm. Didn't know it worked that way with old ASP and ADO. I am spoiled with .NET and my collections. Don't really know what to say.

One possiblility: Put all...

Hmm. Perhaps an output parameter that tells you if there was an error at the end?

What are you using for your front end? I don't see why you cant read all of the tables(recordsets), THEN display what you want.

For those that love being complicated for the sake of it:

create table nos ( i int)

create table a (i int)

insert into nos select 4 union all

 select 5

declare @i int

declare