Thanks for the input, I had to put another step in which built a unique record as follows.

--Declare a temp table to hold the records for the first...