Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden Display More Than 8000 Characters (SQL Spackle) RE: Display More Than 8000 Characters (SQL Spackle)

  • January 27, 2011 at 10:30 am

    #1279218

    nigel. (1/27/2011)

    Thanks Jeff, nice article.

    Spotted a minor typo in the first code example, has SliceDate instead of SliceData for the column alias.

    I know it has no real effect. But, knowing what a perfectionist you are .:-)

    That's one of my most consistent typeo's... date and data. I post an update to the article that Steve can do a replacement with. Thanks for the catch and the compliment, Nigel.

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