Unfortunately I dont have access to that information. The tables are created by another department. But I appreciate the help you provided.

Shoot the version is 2000. Sorry for the mix up.

Copied and pasted with the missing part and received the error below.

Msg 156, Level 15, State 1, Line 1

Incorrect syntax near the keyword 'with'.

Msg 195, Level 15, State 10, Line...

I appreciate the help, new to SQL.

select

rn = row_number() over (partition by a.yyyymm, a.rcvdate, a.dispdate order by c.issuedate asc),

a.yyyymm,

...

SQL 2012

Thank you for the tips, when I run the query I receive this error:

Msg 195, Level 15, State 10, Line 2

'row_number' is not a recognized function name.