Temporary Tables

Results 1 to 3 of 3

Thread: Temporary Tables

  1. #1
    Desperate Trev Guest

    Default Temporary Tables

    Does anyone know if it&#039s possible to use temporary tables created within stored procedures as recordsets on an ASP?<BR><BR>I keep trying but without success.

  2. #2
    Join Date
    Dec 1969

    Default RE: Temporary Tables

    I haven&#039t 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)&#062;3));<BR><BR>

  3. #3
    Not So Desperate Now Trev Guest

    Default RE: Temporary Tables

    You&#039re 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 &#039new&#039 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 &#039see&#039 the results on my ASP.<BR><BR>Cheers Gavin!!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts