It’s going to be a lot of data, trial… and hopefully not many failures
Latest from the Blog
This is a note on a surprising difference and kind of a follow-up on a RPGPGM.COM article (so go read it first and put the site in your favorite!). I already commented on it there, but thought it would be worth a small post. Try to guess the result for the following statement, then letContinue reading “MAX/MIN, Scalar vs Aggregate function and NULLs #db2fori #ibmi”
In July, I left a position as a data manager on SQL Server (and a bit of MySQL) to start as a database developer on… Db2 … for i. I’m now going through a paradigm shift and transfer some knowledge to the platform. I had a use case for ‘CONCAT_WS‘. Concatenate 0, 1 or moreContinue reading “a CONCAT_WS-like on #db2fori #ibmi”
It’s amazing to see how Microsoft keep on improving T-SQL. I was happily surprised to hear that GREATEST and LEAST are comming to Azure SQL Database from Version 2016 on… however only on Azure SQL. I’m currently ‘stuck’ with SqlServer 2017 on Premise (at least it is not any out of support version, like 2008R2)Continue reading “Multi-Column “Aggregation” MAX(), MIN(), COUNT() & Co with #SQLServer”
Get new content delivered directly to your inbox.