Arthur Fuller
fuller.artful at gmail.com
Sun Apr 22 18:59:18 CDT 2012
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/>