Sean;

You are ahead of me with your post. I just got finished formatting the code as well. At first glance, not only the multiple execution paths, I would almost guarantee the views are not indexed.

I'm not a big fan of calculations & case logic in Order clauses...

Can we get an idea what efforts were done to tune this script?

Kurt