Home Forums SQL Server 2008 T-SQL (SS2K8) T-sql select - like RE: T-sql select - like

  • October 6, 2012 at 1:17 pm

    #1546439

    CELKO (10/5/2012)

    You are not just new to the forums, but have never read anything about RDBMS.

    Backoff the new guy, Joe. You don't know if he created the denormalized data or not. Even if he did, that's not teaching and there's no need for that kind of comment.

    What you have is an attempt at a variant record in several different 1950's threu 1970's file systems.

    BWAA-HAAA!!! You always say stuff like that but aren't you still using a 1950s push-stack to convert Adjacency Lists to Nested Sets?

    If you do nto care about being a good SQL programmer, there are several kludges for splitting this string into separate values.

    Once again, you're totally out of line with such a comment. Good programmers will, in fact, use some of the "kludges" to normalize the data if they're allowed and to simply use the data if they're not. Heh... and it's not nearly as bad as the push-stack kludge. 😉

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