Home Forums Article Discussions Article Discussions by Author Discuss content posted by Amit Gaur Convert String to a Table using CTE RE: Convert String to a Table using CTE

  • December 15, 2009 at 8:40 pm

    #1092790

    schedde (12/15/2009)

    Create Table #Id (n int)

    declare @d datetime

    set @d = getdate()

    declare @s-2 varchar(max)

    set @s-2 = '3903044,7569634,3947703,4397641,8304414,3889301,504543,5543592,2468890,644965,3343....

    EXEC Util_ReadIdList @IdList=@s

    select datediff(millisecond, @d, getdate())

    Thanks, schedde. Do me just one more favor to fix the sudden huge width your post above caused. Edit it and go to the last visible character of the set statement and delete the huge number of blanks that were inserted after that to get this thread back to a normal size. Thanks.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)