While trying to write a report that lists the top paths that visitors took through an application I ran into something I couldn't figure out how to address in SQL. I ended up scripting a solution, but ...