I haven't tried this, but you could run this query in your stored procedure - This will create a new table ,then you get your results from there<BR><BR><BR>temptable is the name of the table you want to use<BR><BR>SELECT Table1.* INTO temptable<BR><BR>FROM Table1<BR><BR>WHERE (((Table1.ID)>3));<BR><BR>
You're a diamond. This works!!! Instead of selecting the result set into a #temporarytable or ##temporarytable (global) within the stored procedure as I had been trying, this creates a 'new' table that I can call from another procedure and just pass my parameters to it as it is created to keep the result set as small as possible. I can now 'see' the results on my ASP.<BR><BR>Cheers Gavin!!!!