[dba-SQLServer] SQL 2000 question

Yes it supports ##temp tables

Sent from my mobile

On Apr 22, 2012, at 4:59 PM, Arthur Fuller <fuller.artful at gmail.com> wrote:

> It's been several years since I have had SQL 2000 installed locally, but
> lately I've had occasion to use it. Fortunately, SQL 2005 is also
> installed, so I can use SSMS instead of resorting to the dinosaur
> Enterprise Manager.
>
> Currently, there are 5 procs executed in sequence. Each uses one particular
> table, scoping it by a date range and another parameter, then joins the
> result to a second table to obtain values to update the original table. The
> procs are always executed in sequence.
>
> Now, my question. Does SQL 2000 support global temp tables?
>
> If so, then I could create the temp table once, and share it among the 5
> sprocs, letting each of them join to its  table of interest to obtain the
> values to use in the update.
>
> If not, then I could create a local temp table and fold the 5 sprocs into a
> single larger sproc, but I'd rather not do that because I like the
> atomicity of the current setup (each sproc doing exactly one thing).
>
> Can someone with either a good memory or a copy of SQL 2000 installed
> please check this out for me?
>
> TIA,
>
> --
> Arthur
>
> The most likely way for the world to be destroyed, most experts agree, is
> by accident. That's where we come in; we're computer professionals. We
> cause accidents.
>
> -Nathaniel Borenstein<http://www.quoteland.com/author/Nathaniel-Borenstein-Quotes/63/>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>