• wolfkillj (1/25/2012)


    Welsh Corgi (1/25/2012)


    The function is wrong.

    Do you have a tested solution with that function?:w00t:

    Oh, and by the way, I tested the function you posted earlier. It definitely works properly on SQL Server 2008, although I wouldn't recommend this kind of function for the reasons explained by Jeff Moden here:

    http://www.sqlservercentral.com/articles/Tally+Table/72993/

    Well I'm not using 2008 and if I was I would not need this work around.

    Thanks for your suggestion but it is time to move on.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/