• I thought it was a very interesting article with an interesting concept.

    One note is that there is a set based way of generating the helper table that may be more efficient. Jeff Moden described it in http://www.sqlservercentral.com/articles/TSQL/62867/ .

    ---
    Timothy A Wiseman
    SQL Blog: http://timothyawiseman.wordpress.com/