SAP HANA Trick: DISTINCT STRING_AGG
Nowadays, many SQL implementations offer some form of aggregate string concatenation function. Being an aggregate function, it has the effe...
-
Every now and then, people are puzzled by the precise status and extent of MySQL support for dynamic SQL. Statement Handling MySQL support ...
-
Handling cursor loops in MySQL keeps puzzling people . Single Cursor Loops The common case is to have a simple cursor loop. Each record is ...
-
To whom it may concern - a quick hands-on guide for running the Pentaho BI server behind a proxy Prerequisites This post assumes you're ...