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