SQL is a powerful tool for BI analysis, as it allows you to manipulate, transform, and combine data from different sources. One of the functions that you can use to perform these tasks is CONCAT ...

Changes all use of '||' in stored procs to the concat function. It was more of a challange than I originally thought, but I got it done in less time than updating and testing all the several thousand ...