Indeed you are right about NH performance. I've fought with it from the beginning and still am. With just the right tweeks, and the proper alignment of stars,...

Nice! Thanks for introducing me to CTE's 🙂 And I don't know why I didn't think of doing a MAX on the date, but that would have made...

Very handy and free! Just a couple requests for some sp guru out there:

Can anyone modify this to output in VB as well?

It would also be nice to change...