Home Forums SQL Server 2005 T-SQL (SS2K5) create variable for IN statement RE: create variable for IN statement

  • October 1, 2012 at 7:40 am

    #1543975

    GilaMonster (10/1/2012)

    I wouldn't use that function. The loops will make it very slow.

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

    I hate loops as well, but it will be ok if used for splitting a single list of values. Actually, properly written loop splitter will outperform Jeff Moden tally-table based split for a single list, however, if you need to use the split function for a set of rows, you better use mentioned Jeff's one.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]