RE: Mathematics/Algorithms in SQL

SSC Guru

Points: 186127

December 5, 2017 at 12:49 am

#1970652

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

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden