The setup portion is what I was referring to in my last post. Please provide sample data like this in the future, it makes it easier on us. ...

Sulaman, could you please provide the sample data in the manner explained by the article in my signature? That would make it much easier for us to work with...

Unfortunately, there isn't a way that is quite that easy in 2000.

For a quick and dirty approach, you could do something like:

SELECT SUM(usecounts) TotalUses, pagesused, sql

FROM master..syscacheobjects WHERE usecounts >...

Ian, Manu, thanks for the feedback. I meant to include in the original post that the table did not have any blob columns in it, sorry about that. ...

The AND NOT's can get pretty confusing, so just to explain this a bit more:

The problem is the logic of your where clause. Here's what you're saying(assuming case sensitivity...

Lynn Pettis (11/24/2009)

---

If you're going to "bump" your post, how about posting something usefull, like DDL for your tables, sample data, and expected results. That may actually get you...

Just so that people reading this later don't get the wrong idea, can you confirm the...

This strikes...

Yep, I changed the aliases a few times and missed that one, my fault. (The parser would have caught that one if I had checked it, so that one...

Welcome to the forums. This should get you pretty close, but it's untested; so I may have screwed up an underscore or 12. To get tested code in...

Why do you want to get rid of the temp table? Or do you mean you'd like to get rid of the while loop that relies on the temp...

Jeff Moden (11/23/2009)

---

It's not the code... it's the data. You need to find out which VARCHAR data isn't valid in that column. Start with using ISDATE and go...

Using that format, you're lowering your pool to 16 from 36, which only gives you a total 16,777,216 possible permutations and increases your rate of failure over what was originally...

That seems wrong to me still. I think it should probably be:

SELECT [CountryCode], sd.name

FROM MyDB.dbo.Country c

LEFT JOIN MASTER.dbo.sysdatabases sd (NOLOCK)

...

A couple facts about this setup:

You can never rely on 2 random numbers to be unique, no matter how big the pool. Even in a pool of 40 billion...