Glad to hear that.

Did you try my profiler proposition to see what the statement did look like?

I don't think so.

Maybe you should suggest it. I would do it but it wouldn't look to good .

I didn't see this one... It's not because I didn't take my time .

BTW my solution works .

[EDITED]

Almost 3100 now

Tx. Now I can say I'm almost in range of Frank .

I knew I was missing something... Much better solution .

I'm glad I don't have to drink a lot recently .

It's always simpler to document... assuming the guys read it. Makes better code anyways.

Hey Noeld, wanna race to 3k posts ?

[EDIT]

DAMN it...

Please stop using this syntax, it will be absolete in Yukon :

[Employee Name] = EMPLOYEE_NME,

Always the small things that trip you up .

First of all 60 days is not the same as 2 months, so I presumed that you needed 2 months back in the query.

Here it goes :

Select DISTINCT Customer_ID...

Damn I'm getting too slow for this .

Gonna have to retire when I hit 3k.

You don't make it count down. Add a datefield with default getdate().

Then the query would be something like this :

Select * from dbo.MyTable where DateField between dateadd(HH, -2,...

This is something I did for someone who wanted to find the unused dbs in its mssql/data directory.

You should be able to adapt this script yourslef :

--list the database...

Yup, that's almost as sneaky as Noeld's solution to join to stored procs .