With SQL Server 2005 recently released, one of the things that many people are looking for are some guidelines for working with the new product. New author NandaKishore brings us a list of best practices that should give you a start.
2008-03-14 (first published: 2006-01-04)
121,451 reads
By Patrick
SQL Server Audit is an efficient way to track and log events that occur...
I presented at SQL Saturday Pittshburgh this past weekend about populating your data warehouse...
By Steve Jones
A customer was asking recently about the RPO for their estate, and I showed...
Comments posted to this topic are about the item The Modern Algorithm of Chance
Comments posted to this topic are about the item Use Logic Apps To Save...
Comments posted to this topic are about the item AWS Services Using SQL for...
I have this data in my Customer table:
CustomerID CustomerName 1 Steve 2 Andy 3 Brian 4 Allen 5 DevinI run this code:
SELECT
t.CustomerID
, c.value
FROM
( SELECT
CustomerID
, STRING_AGG (CustomerName, ',') AS me
FROM customer
GROUP BY CustomerID) t
CROSS APPLY STRING_SPLIT(me, ',') c;
What is returned? See possible answers