I have set up an Azure Virtual Machine with a SQL Server 2016 Standard Edition image. I have installed an instance of Analysis Services Tabular on the machine and configured endpoints such that I can access it from my local machine. I have deployed SQL Server, SSAS Multidimensional, and SSAS Tabular databases to this machine. I am able to connect
Tag: azure
Optimal way to concatenate/aggregate strings
I’m finding a way to aggregate strings from different rows into a single row. I’m looking to do this in many different places, so having a function to facilitate this would be nice. I’ve tried solutions using COALESCE and FOR XML, but they just don’t cut it for me. String aggregation would do something like this: I’ve taken a look