Wayne:

You need to admit that you need help.

I'd like to invite...

True enough, Gail. I'm guilty both of assuming that Flo is on 2005/2008 and that a dashboard application looking at huge files only needs a "close enough" value....

Hey Paul, I followed your link about the new flag. My son has lived in Dunedin for years now, but never mentioned this to me. As...

Greetings Flo:

Never saw the bottle, but you're welcome to anything I ever post up here, as is everyone else. I wouldn't think you'd need my code after you...

My thought exactly, Lynn. It may be a case of procedural addiction. No cursor or while loop, but still a sort of step-by-step approach.

How about this one? Fresh off the presses...

1. Create temporary table "A"

2. Populate it with base ids

3. Query table "B" and update one column in...

So are we just saying it depends?

Seriously, if this can be boiled down to performance characteristics tied to a matrix of variables, it would be a valuable resource...

How many phrases are you going to search for? I've got a solution that is child's play to code, but it's never been tested at large volumes. ...

Hey Flo:

I haven't seen anything. When, where, and how did you send it? 🙂

If you don't already have one, you will really find it to your advantage to create a calendar table and prepopulate several years in advance with dates, flagged as weekends...

One other thought, although I know and love the ORDER BY CASE technique...

If you will be using this sort order in many places, and may be adding additional items in...

This sounds like a SELECT DISTINCT query. It returns only the unique combinations of all columns included in the SELECT list.

While I'm sure your solution will work fine, it seems like overkill to fire a trigger and delete a row every time a user hits a new page. ...

agreed

We're not talking about linked servers... I KNOW the answer to that question.

Not sure the table sizes justify separate disk resources, but they could live where the load is lightest.

Query...