Okay, abbreviated response, should have written that such that you (Jeff) would have known it was dirrected to the OP. Sorry. I was just adding additional info to...

Okay, your choice. We can just give you the answer and hope you learn something, or we can direct you to other resources so you can to some reading...

And that assumes that the value in RANK can have duplicates. That wasn't discussed and the sample data didn't have that problem.

Considering the forum it was posted, and the content, I don't have a problem. Of course...

If your web sites are internet facing, you either need per processor licensing or you may want to look at the web version of SQL Server.

First thing I'll do is point you to BOL (Books Online, the SQL Server Help System that can be accessed by pressing the {f1} function key while in SSMS).

You want...

Alvin Ramard (10/2/2009)

I can't read it either!!!

Lynn, the link is not working for me. It tries to take me...

Alvin Ramard (10/2/2009)

I can't read it either!!!

Lynn, the link is not working for me. It tries to take me...

Good to know. Hopefully when we get thereI'll still remember. 😉

Okay, here's an I can't read moment. 😛

The link to the aforementioned article is located in my signature block below. It is the second article.

Title of the thread: what is net change method

As this looks like a performance issue, please read the second article I have referenced in my signature block. Following the instruction in that article will get you the...

Don't think my wife would approve. 😉

Sample code.

create table dbo.MyTestTable (

MyTestTableID int identity(1,1),

MyDate datetime default(dateadd(dd,datediff(dd,0,getdate()) - 1, 0)),

ADataValue int

)

;

insert into dbo.MyTestTable(ADataValue)

select 1

;

select

...