• mdonnelly (2/27/2009)


    David McKinney (2/27/2009)


    mdonnelly (2/27/2009)


    Peter E. Kierstead (6/16/2008)


    I'll index this table appropriately, and wallah!, home-grown full-text index...

    This would have been on the bubble of being excusable had the original article not had a big, bold Viola' in it.

    While I'm being pedantic...Viola is a musical instrument while voilà is French - but très amusant! Bravo.

    Recognizing my own short comings, this is exactly why I would have ignored it had it read "vallah".

    Yeah, thanks David. I didn't think I saw any stringed instruments in the original article!

    Ooo eee, ooo ah ah

    ting tang

    voilà voilà, bing bang

    Nice article, and great discussion. I must admit, I've been so buried in other work, I never had time to explore how powerful ROW_NUMBER() is. Might not have even paid attention to it 2 years ago.

    And thanks McD for the example with the middle nesting level removed. The original looked more complicated than it had to be.