Write a SELECT statement that has a WHERE clause with selection criteria that gives you the row that is "last" by your definition.

There is no inherent last row in a...

This seems to work OK:

declare @t table 
(
 MachineID INT NOT NULL, 
 EventID INT NOT NULL,
 State varchar(3) NOT NULL,
 PRIMARY KEY CLUSTERED (MachineID ,EventID)
)

-- Load on/off state transition events
insert into @t
select
 x.MachineID,
 x.EventID, 
 State...

Ryan, I modified your script to use INT temp tables, instead of BIGINT, and got almost an 18% reduction in runtime.  The following is the result of finding all primes...

Since he did not provide the actual code that he was having trouble with, or the error he was getting, it is a little hard to provide help.

"Damn it Jim,...

You can start the job on the other server using the OSQL command within an Operating System command (CmdExec) job step or using XP_CMDSHELL.

Well, somtimes you just need a cursor.

There are no dumb tools, just dumb workmen. 

Try this:

Script to analyze table space usage

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61762

You can also backup to multiple files using the regular SQL Server backup command, but if you need to compress them, you will have to use a file compression utility...

If you want a date table, you can use my own personal favorite.

Date Table Function F_TABLE_DATE:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519

Good stuff Ryan!

Did you compare the runtime against any of the other code posted on this thread?