Another use of the LIST function
- Last UpdatedSep 29, 2022
- 1 minute read
- PI System
- PI OLEDB Enterprise 2019
- Developer
SELECT LIST((Name + ' = ' + cast(Value as String)), ', ') "Connection Status"
FROM System..ConnectionStatus;
Reports the connection status as comma-separated list.