So here is my final code - not perfect but it gets what I needed, along with some extra null rows. I just dump the output into excel and remove...

Hi Eirikur,

I modified the final select as follows to include the DENSE_RANK to get line number.

SELECT

CD.memberID

,TA.EventSeq

,TA.EventRefSeq

,DENSE_RANK() OVER (ORDER BY TA.RefStartDate)...

Yes, you are correct. We are using a vendor application and apparently when it was implemented table A stores line level history with the EventReferralSequence field. But they did not...

Eirikur,

This is excellent!!

Thank You so much for responding and for the code. Learn something new with the crosstab.

I will work on getting the decision_sent_date to begin with the second...

Thanks for responding.

The tables are linked by the two first columns: memberID and EventSeq

I am selecting all the columns for table A, the last column from table C and the...