Sean,

I'm realizing something. Let's say that you have three records in the ReturnsPros table that have the same data in six columns:

ProgYear = '13'

RiskNonRiskFlag = 'N'

Region = 'Central'

ModelName = 'Mustang Conv'

MFG = 'FRD'

Cycle ='1'

However, the ReturnDate column will be unique in those three records. What I am getting at is that the first "set" of records represents a grouping in the VehicleDetail and the ReturnDates represent a "SUBSET" within the VehicleDetail.

Isn't a partition a bit like a "group by"? If that is so, what we need is a subpartition. Here's the rub. The ReturnDate column is null in most records before the process begins, so you can't group on nothing with your partition. If we could, we would have the problem solved.

You don't have to do anything. I just wanted to give you an update but if you have any ideas, I would appreciate it.