2011-11-18
2,980 reads
2011-11-18
2,980 reads
2011-09-27
2,758 reads
I presented at SQL Saturday Pittshburgh this past week about populating Your data warehouse...
By Steve Jones
A customer was asking recently about the RPO for their estate, and I showed...
By Steve Jones
I’m hosting a webinar tomorrow with Rie Merritt from Microsoft. We’ll be talking about...
Hi All, I am currently testing the Table Partitioning to implement in SQL server...
Comments posted to this topic are about the item STRING_AGG's behavior
Comments posted to this topic are about the item The Role of Databases in...
CREATE TABLE t0 ( id INT PRIMARY KEY , field1 VARCHAR(1000) , field2 VARCHAR(MAX)); INSERT INTO t0 SELECT gs.value , REPLICATE ('X', 1000) , REPLICATE ('Y', 1000) FROM generate_series(1, 10, 1) gs; GO
select STRING_AGG(field1, ';') within group (order by id) from t0;
select STRING_AGG(field2, ';') within group (order by id) from t0;