temporary tables vs. stored procedures 
Author Message
 temporary tables vs. stored procedures

Would appreciate any advice regarding using temporary tables vs.
stored procedures.  I'm running several stored queries in batch
mode.  Many of the queries contain nested queries.  Since you
cannot issue a select from (on a stored procedure - obviously,
it must be a table), the only way I've come up with is to either
create views which I can select from, or create temporary tables
within my stored procedure.  Any input?  Thanking you in advance,
Regards,
Michelle Turner



Mon, 10 Jul 2000 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. temporary tables in stored procedures/parameter views vs stored procedures

2. Storing the result of a stored procedure call in a temporary table

3. For Every SQLServer7 Programmer : variables Vs. temporary tables to store

4. image field from stored procedure vs view vs table

5. Stored Procedure temporary table failing - HELP!!!!

6. alter temporary table within a dynamically built stored procedure

7. Results from stored procedure to temporary table?

8. Stored procedure -- referencing temporary tables in

9. Cannot use ADO's MoveLast at temporary table of stored procedure

10. Temporary table in a stored procedure

11. DTS, Stored Procedure and Temporary tables

12. Temporary tables and stored procedures


 
Powered by phpBB® Forum Software