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 9:54 pm

    #1092798

    Jeff Moden (12/15/2009)

    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.

    BWAA-HAAA!!!! Never mind... that SET statement is so wide that it just confused the forum software and it only looks like there's a lot of blank space there. If you highlight the SET statement, the rest of the numbers suddenly show up.

    --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)