I have a function that does it all for you. Inparameters are data and boolean wether or not checkdigit is included.

Return value is either checkdigit or true/false if checkdigit was...

DELETE FROM MyTable WHERE MyDateTimeField <= DATEADD(dd, -60, GETDATE())

Or the more elegant solution:

SELECT dbo.Customers.ID + 1 AS CustomerID, (SELECT MIN(Custs.ID) FROM dbo.Customers Custs WHERE Custs.ID > dbo.Customers.ID) - dbo.Customers.ID - 1 AS Items

FROM dbo.Customers

WHERE (SELECT MIN(Custs.ID) FROM...

A very fast approach is using following:

SELECT dbo.Customers.ID + 1 AS CustomerID

FROM dbo.Customers

WHERE (SELECT MIN(Custs.ID) FROM dbo.Customers Custs WHERE Custs.ID > dbo.Customers.ID) - dbo.Customers.ID > 1

UNION

SELECT dbo.Customers.ID - 1...

You could create a cursor for the #temp table and delete rows one by one with the syntax WHERE CURRENT OF.

The easy way to do it is to add a new field to the table, call MyID as an IDENTITY (1,1) INT

And now comes the tricky part...

ex: select col1, col2, col3,...

CREATE TABLE #PossibleWorkMinutes

  (

   Client_Rep VARCHAR(50),

   Begin_Work DATETIME,

   End_Work DATETIME,

   TotalWorkDayMinutes INT

 &nbsp

INSERT INTO #PossibleWorkMinutes

SELECT  Client_Rep,

  MIN(Begin_Work),

  MAX(End_Work),

  NULL

FROM  MyTable

GROUP BY Client_Rep

UPDATE  #PossibleWorkMinutes

SET  TotalWorkDayMinutes = DATEDIFF(mi, Begin_Work, End_Work)

CREATE TABLE #WorkDoneMinutes

  (

   Client_Rep VARCHAR(50),

   WorkDoneMinutes INT

 &nbsp

INSERT INTO #WorkDoneMinutes

SELECT  Client_Rep,

  SUM(DATEDIFF(mi, Begin_Work, End_Work))

FROM  MyTable

GROUP...

CREATE TABLE #Temp

(

NewRowID INT IDENTITY (1, 1) NOT NULL,

   OldRowID INT

)

INSERT INTO #Temp (OldRowID)

SELECT MyTable.Col1 FROM MyTable ORDER BY MyTable.Col1

UPDATE MyTable

SET MyTable.Col1 = #Temp.NewRowID

FROM MyTable, #Temp

WHERE MyTable.Col1 = #Temp.OldRowID

DROP TABLE #Temp