If you are looking for a query I'd recommend searching our query page:http://opendentalsoft.com:1942/ODQueryL ... yList.aspx
If you can not find something that works you can request your own query here:http://opendentalsoft.com:1942/ODQueryR ... tForm.aspx
If you go with the request route we will contact you to clarify everything about your request and quote you soon there after.
I am curious as to how MAX(EntryDateTime) does not work for you in terms of finding the 'active' procNote. The WHERE clause in the pn2 sub query requires we look at proc notes associated to the pn1 outer queries procedure and by pn.EntryDateTime = ... MAX(pn2.EntryDateTime) we are only looking at active procNotes.