Transactions CAN wrap multiple SQL batches and GO commands.

Oberion's, I think.

That's probabrly why, Jeff. I did some work for an insurance company several years ago and...

That example can't really be used here Jeff because it assumes the existence of a useable RowNum column and that just doesn't exist in the general Web Page/Rows case. ...

The only problem is, there already is something called a...

Just add an "ORDER BY Student, AttendDate" to the end of Jason's (Joel's?) query.

Oops, wait a minute, I am getting my threads mixed up... Never mind.

Actually, Jeff, it's not that different from what I am already doing, except that it is dependent on an Index that may not exist.

The query that I posted above has been doing pretty well. I'm testing it on a 3-million row table with substantial column width (sysobjects plus about 200 more bytes)...

My random and ad-hoc tests leads me to believe that this is about as good as you can do

Create Proc spTableRows_Window(@startingRow int, @rows int)

AS

--NOTE: some stuff stolen from Jeff...

Rats! I forgot to check, sorry.

OK, no answers yet, but this is what I have come up with:

--====== Load up the working table

SELECT b.Record_No

, b.Item

, b.PlnQty

, Rank()...

Also, this bit here:

...

SELECT @@fetch_status

WHILE @@fetch_status = 0

BEGIN

IF @ChkItem <> @CumItem

BEGIN

Set @ChkItem = @CumItem

Set @mCid =...

Please put your data into a form that we can use for tests (like INSERT statements). Here is a link that explains this:http://www.sqlservercentral.com/articles/Best+Practices/61537/

Something like this:

Select *, row_number() Over(Partition by StudentID Order by EntryDate)

From Students