Hi all. I'm running into this problem in our environments and unfortunately it happens "off and on", meaning somepackages get modified, some do not and it's annoying to say...

I dont anticipate it being called much since its more of a report type query, but I'm saying that today, who's knows whats going to happen 4 - 6 months...

After I wrote that, I was looking at some of the other forum posts for inspiration and I'm leaning on what you said. Would likely be better to have...

GilaMonster (12/13/2007)

---

The two are equivalent, but you should convert to the inner join format. The old style joins are deprecated in SQL 2005 and will not work in future editions.

Regarding...

Steve Jones - Editor (10/10/2007)

---

Frank,

What are you querying on? Maybe you can give us the table schema and let us know how the queries are structured.

If there are indexes on...