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 ...

I have a few ideas on how to do this, but am worried about going down an overcomplicated path, one littered with cursors, functions, and inefficiencies ...