NaomiP
4Penny.net
Points: 7100

3/16/2022 4:27:00 PM

STRING_AGG SQL 2017 (14) or later

* This article, and all our great SQL (General) documentation, Is available on the SQL (General) menu

New SQL features are hard to use because it's years before I get customers that have the new version of SQL

But this feature came out in SQL 2017, and it's becoming available.

 

STRING_AGG will turn this

Into this

 

4Penny.net
Version: All
Section: SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3