We know that... the 2nd page of posts is all about that.

For everyone who thinks that table variables are kept in memory only :

DECLARE @Temp TABLE

(RowId int NOT NULL IDENTITY(1, 1),

Col1 varchar(20) NULL,

PRIMARY KEY CLUSTERED (RowId) )

Select * from @Temp...

Here's a sick idea :

IF EXISTS(SELECT name FROM sysobjects WHERE name = N'Test_LastBilledTable' AND type = 'U')

DROP TABLE Test_LastBilledTable

GO

CREATE TABLE [Test_LastBilledTable] (

[Customer_Id] [int] NOT NULL ,

[Last_Billed_Date] [datetime] NULL ,

[Job_Id]...

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.