No worries, I figured it out by making a view of the data i needed then making another view from that view I created, I added some reference tables. It...

I'm sorry. I am looking for all cases where TermDate is NULL or any cases where TermActionCodeID = 'U' or TermActionCodeID = 'B' or TermActionCodeID = 'X'....

I have an attached spreadsheet of the TOP 100 rows

I'm still receiving the record 00CV000773 with the TermActionCodeID of X.

Should the line below be changed?

ROW_NUMBER() OVER(PARTITION BY CaseNumber1 ORDER BY TermDate DESC) AS rn

What exactly does the PARTITION BY...