All I can say is "wow"! You did this without variables, dynamic SQL or a top clause. That is amazing to me. I messed up on the RiskNonRisk column which you probably discovered wouldn't match between tables. The delivery dates were no big deal for such a small set. You could have placed almost anything in there that was not ahead of the returns dates in the VD table. As the Russians say, "Thank you a thousand times!"

I went back and changed what I sent and will post it, just to be sure everything is what is should be. But the important thing is the benchmark. I will test your code and let you know how much time it saved. That should be the fun part. This will be on approximately 250,000 records. Anyway, the following is what I should have sent:

--===== Create the test table with

CREATE TABLE [Vehicle Detail]

(

VIN Varchar PRIMARY KEY CLUSTERED,

SerialNumber Varchar 50,

ProgYear Varchar 2,

LeaseCycle Varchar 2,

ModelName Varchar 50,

RiskNonRiskFlag Varchar 2,

Region Varchar 50,

MFG Varchar 50,

ReturnDate Datetime,

)

CREATE TABLE [Returns Pros]

(

Region Varchar 50,

ProgYear Varchar 2,

RiskNonRiskFlag Varchar 2,

MFG Varchar 50,

LeaseCycle Varchar 2,

ModelName Varchar 50,

ReturnDate Datetime,

UnitCount Int

)

--===== Insert the test data into the test table

INSERT INTO [Vehicle Detail]

(VIN, SerialNumber, ProgYear, LeaseCycle, ModelName, RiskNonRiskFlag, Region, MFG, DeliveryDate, ReturnDate)

Select 'ZL152983', '1FADP3K22ZL152983', '13', '1', 'FOCUS', 'R', 'SOUTHEAST', 'FRD', '07/04/2012', NULL UNION ALL

Select 'ZL185223', '1FADP3K20ZL185223', '13', '1', 'FOCUS', 'R', 'SOUTHEAST', 'FRD', '07/04/2012', NULL UNION ALL

Select 'ZL196536', '1FADP3F27ZL196536', '13', '1', 'FOCUS', 'R', 'SOUTHEAST', 'FRD', '07/04/2012', NULL UNION ALL

Select 'ZL265273', '1FADP3F27ZL265273', '13', '1', 'FOCUS', 'R', 'SOUTHEAST', 'FRD', '07/04/2012', NULL UNION ALL

Select 'ZL196580', '1FADP3F2XZL196580', '13', '1', 'FOCUS', 'R', 'SOUTHEAST', 'FRD', '07/04/2012', NULL UNION ALL

Select 'ZL196590', '1FADP3F22ZL196590', '13', '1', 'FOCUS', 'R', 'SOUTHEAST', 'FRD', '07/04/2012', NULL UNION ALL

Select 'ZL171198', '1FADP3F29ZL171198', '13', '1', 'FOCUS', 'R', 'SOUTHEAST', 'FRD', '07/04/2012', NULL UNION ALL

Select 'ZL171258', '1FADP3F21ZL171258', '13', '1', 'FOCUS', 'R', 'SOUTHEAST', 'FRD', '07/04/2012', NULL UNION ALL

Select 'ZL171268', '1FADP3K27ZL171268', '13', '1', 'FOCUS', 'R', 'SOUTHEAST', 'FRD', '07/04/2012', NULL UNION ALL

Select 'ZL211529', '1FADP3F2XZL211529', '13', '1', 'FOCUS', 'R', 'SOUTHEAST', 'FRD', '07/04/2012', NULL UNION ALL

Select 'ZL211532', '1FADP3F2XZL211532', '13', '1', 'FOCUS', 'R', 'SOUTHEAST', 'FRD', '07/04/2012', NULL UNION ALL

Select 'ZL211617', '1FADP3F27ZL211617', '13', '1', 'FOCUS', 'R', 'SOUTHEAST', 'FRD', '07/04/2012', NULL UNION ALL

Select 'C5216918', '1ZVBP8DM2C5216918', '11', '2', 'MUSTANG CONV', 'R', 'ATLANTIC', FRD', '12/03/2011', NULL UNION ALL

Select 'C5216923', '1ZVBP8DM2C5216923', '11', '2', 'MUSTANG CONV', 'R', 'ATLANTIC', FRD', '12/03/2011', NULL UNION ALL

Select 'D1220647', '2G1WC6E30D1220647', '13', '1', 'IMPALA', 'R' , 'CENTRAL', 'GMC', '12/03/2011', NULL UNION ALL

Select 'D1221984', '2G1WC6E31D1221984', '13', '1', 'IMPALA', 'R' , 'CENTRAL', 'GMC', '12/03/2011', NULL UNION ALL

Select 'D1259402', '2G1WC6E30D1259402', '13', '1', 'IMPALA', 'R' , 'CENTRAL', 'GMC', '12/03/2011', NULL UNION

INSERT INTO [Returns Pros]

(Region, ProgYear, RiskNonRiskFlag, MFG, LeaseCycle, ModelName, ReturnDate, UnitCount)

Select 'Atlantic', '11', 'R', 'FRD', '2', 'MUSTANG CONV', '6/3/2013', 2, UNION ALL

Select 'Central' '13', 'N', 'GMC', '1', 'IMPALA', '6/3/2013', 3, UNION ALL

Select 'Southeast', '13', 'R', 'FRD', '1', 'FOCUS', '1/4/2014', 12