I'm sorry about the "roughness" but chalk it off to my first experience on this site. I was going to test the inserts but ran out of time here...

Here you go. Now you can test your query (I hope) The VINs are not real for obvioius reasons.

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

CREATE TABLE [Vehicle Detail]

...

Sorry, I totally missed the best practices the first time around. I will work on that this afternoon. It's exciting to think of accomplishing my goal without loops....

Thanks for your encouragement! Sorry, I have been on vacation. I will include the two tables and some code now.

Vehicle Detail:

VinSerialNumberProgYearLeaseCycleModelNameRiskNonriskFlagRegionReturnDate

ZL1529831FADP3K22ZL152983131FOCUSRSOUTHEAST

ZL1852231FADP3K20ZL185223131FOCUSRSOUTHEAST

ZL1965361FADP3F27ZL196536131FOCUSRSOUTHEAST

ZL2652731FADP3F27ZL265273131FOCUSRSOUTHEAST

ZL1965801FADP3F2XZL196580131FOCUSRSOUTHEAST

ZL1965901FADP3F22ZL196590131FOCUSRSOUTHEAST

ZL1711981FADP3F29ZL171198131FOCUSRSOUTHEAST

ZL1712581FADP3F21ZL171258131FOCUSRSOUTHEAST

ZL1712681FADP3K27ZL171268131FOCUSRSOUTHEAST

ZL2115291FADP3F2XZL211529131FOCUSRSOUTHEAST

ZL2115321FADP3F2XZL211532131FOCUSRSOUTHEAST

ZL2116171FADP3F27ZL211617131FOCUSRSOUTHEAST

Returns Pros:

RegionProgYearRiskNonRiskFlagMFGLeaseCycleModelNameReturnDateUnitCount

Southeast13RFRD1FOCUS1/4/201412

I agree with you about the looping,...