If you send us the table definitions (eg, column names, data types) for each of the tables we might be able to help.

It also makes your code easier to read.

Thanks for all the solutions! I don't know if I will have time to adequately test them all as I'm under a pretty intensive deadline but just from a very...

Thanks! Both of these suggestions do what I need. I look forward to playing around with them and examining their performance relative to the correlated sub-query. I'm sure they are...

It is also worth pointing out that in SQL Server 2000, in addition to making your code more readble, you also get a noticable speed improvement by using ANSI joins.

...

The problem with scheduling it is that it has a very wide range of run times - anything for 2 to 5 days - and if it is running in...

Great article. Disagree with most of it, but it made me rethink a lot of things. On my team only developers, the network manager and the CTO have access to...