Tara-1044200 (6/29/2010)
PaulThe definition very simple which consists of 53 columns with varchar(16) and 4 datetime fields and the row count is 345039256
The reason I asked for the CREATE TABLE statement is so I can see which datetime column is the partitioning key. The row count I wanted is the number of rows that will be left after the delete. I gave you some SQL to run to give that number. I think the row count given above is the total number o rows in the table.