I would like to point out that my little proc has not been shown to be wrong... 🙂

(I was hoping for some sort of feedback.)

Everyone saying the third option is correct if the case is switched needs to look at what is being checked.

What does the current day of the month have to do...

I think the linked servers are not the only culprit here. I actually cringed when I saw these queries.

The first query is JOINing and WHEREing using fuctions. And ...

declare @DoB datetime

declare @Today datetime

declare @YearsOld tinyint

set @DoB = '3/5/1985 6pm'

-- Tests.

set @Today = '3/5/2008 2am'

set @Today = '3/5/2008 5:59pm'

set @Today = '3/5/2008 6:00pm'

--set @Today = '3/5/2008 6:01pm'

--set @Today =...

Aliases ? 🙂

Ah, you beat me to it !

I think a few blocks may be missing.. I would guess "RELATIONSHIP".

Alias ?

If you want the answers, just brute every word found on SQLServerCentral.com through the hash function on this page:

http://www.flashfocus.nl/forum/archive/index.php/t-11371.html

until you match up the 21 hashes of 15829,...

The programmer needs to find a different hammer.

Why?

I thought distributed queries were multi-server queries?

I've been wondering how the joins work across servers also....

Just an FYI: Proper table design will do more for performance than any index could.

Good article, but I disagree with the DATEDIFF/DATEADD statement "The first query can't possibly use an index and performs the DATEDIFF on every row in the table." used on the...

Whoa.. we're all tryin' to help you here. Prozac anyone?

All Scott was saying is that the most basic stuff seems to have not...

I've had this problem in the past and at random times in QA and .Net(C#).

It seems to have been avoided by turning off Named Pipes (by using the Client Network Utility)...

I believe the char(1) is what to convert to, not a character.

0x0a is a Linefeed (could also use char # 10).

0x0d is a carriage return (same as your char #13).

Next time...