So, recently I find myself heavily involved with SAP Data ServicesĀ and data migrations, I know what you’re thinking… thats not real code! And you’re damn
Tag: SQL
Man of Distinct(ion)
Its not often that I learn something new about the fundamentals of SQL. Sure they add to the syntax all the time and you learn
Grouping multiline SQL data using XML
A friend of mine recently asked for help with a bit of SQL he was working on. True, he was in a far away land
Improve Readability using ROW_NUMBER()
What did I ever do without the TSQL Row_Number() functionality. I do remember way back in days of yore (when I had youth, less weight