• ChrisM@Work - Tuesday, December 5, 2017 12:49 AM

    Jeff Moden - Monday, December 4, 2017 5:17 PM

    Alan.B - Monday, December 4, 2017 3:07 PM

    I know that this is an old question bumped back up to the front of the line but I agree that it's an important one. 

    My two cents. With respect to the "mathematics concepts" I'd say to start with 
    Set Theory and The Relational Model.

    Heh... we should definitely do one on "Tuples" as they relate to "Set Theory"... maybe Microsoft will take the hint and finally add an "element ordinal" to the String_Split function.

    As for "Relational Model", I'm just happy there are some people out there that know how to get the current date and time using -T-SQL. 😉

    The "Relational Model" - which Airfix kit to give to which nephew at Christmas??

    The answer is "none".  Keep them for yourself... they're fun to build. 😉  If they know the GETDATE() question, buy them a laptop instead. 😉

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