Steve F. (4/24/2008)

---

If I have a query indexed to the point that its estimated execution plan basically looks like 3% index seek and 97% bookmark lookup, is there much point...

Dang. I found an article online that had to do with this error on 64-bit machines, but it's not at all applicable to 32-bit systems.

I'd say it's time to...

You could either join them or union them to put them together. Which are you looking for?

Most likely, it's "modal". Have you been able to get back to Management Studio by closing the DTS package?

(I don't have any DTS packages to test this on. ...

Is this on a 64-bit system?

What you can do, in some cases, is aggregate on a different column, in a derived table/CTE, then join to that using the image column.

More likely, what you need to...

You're right. With aggregates, it matters. Some other things, too.

I think for Art's query, the criteria in the Join statement will work best.

If they are separate, yep.

Or if you...

Michael Spencer (4/28/2008)

---

Hmm, the question seems to assume that T-SQL is the easiest way to do this. I think using Management Studio is far "easier" and faster.

Right...

Have you tried recompiling the stored procedure? It looks like it needs to refresh the metadata, and that might do it.

I don't understand your second...

Yes, the column has to be created before it can be used in a Where clause, in the case of Row_Number, Rank, etc.

The problem isn't that you're using In in a Case statement. It's how it was written.

Your original query doesn't have the word "Where" in it. That's the syntax...

Matt Miller (4/28/2008)

---

GSquared (4/28/2008)

---

Having StatusID and Active in your Where clause is getting rid of any rows that would have 0 in them. You need to move those to...

That works, Jeremy. Not sure why anyone would do it, but it does work. 🙂