Actually... you've posted this nearly identical question 3 times on this forum and a couple of times on other forums.  Folks have told you how to do this many ways......

Since the row is automatically deleted after 8 days, I'm thinking it's a combination of a computed column and trigger.... or the trigger just has an update/delete.

I'm thinking that deleting...

The date serial between Excel, VB, and SQL Server vary a bit (a day or two in some cases).  And, Excel thinks that 1900 was a leap year... don't use...

Crud... copy and paste error on my part... I didn't include the exec.  Glad you got it working and thanks for the feedback.

Sol,

Recommend you post the CREATE TABLE statement for the table with 2,000,000 rows in it and the proc that creates the report.  Be sure to include the code for any...

My basic strategy is to avoid using a Clustered Index as a PK if the table suffers a large number of Inserts, Deletes, or Updates to the PK columns because...

Doesn't matter what YOU can see... what can the SERVER see?  The server must be logged in as a "power user" that can see shares and machines.  In Enterprise Manager,...

Anytime you try to put a row source or a table name in a FROM, you must (unfortunately) use dynamic SQL...

DECLARE @sql VARCHAR(8000)