Dividing comma seperated values

Blogs

Convert SQL Audit Files to a CSV Using Read-SqlXEvent

By

SQL Server Audit is an efficient way to track and log events that occur...

Control Flow Restartability in Azure Data Factory

By

I presented at SQL Saturday Pittshburgh this past weekend about populating your data warehouse...

Monday Monitor Tips: Knowing Your RPO

By

A customer was asking recently about the RPO for their estate, and I showed...

Read the latest Blogs

Forums

Error while connecting Local DB 2012 in Windows 7 PC using SSMS

By IT researcher

I am trying to access LocalDB 2012 on my Windows 7 SP1 PC. I...

The Modern Algorithm of Chance

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Modern Algorithm of Chance

Use Logic Apps To Save Money In Azure: Data Engineering in Fabric

By John Miner

Comments posted to this topic are about the item Use Logic Apps To Save...

Visit the forum

Question of the Day

Crazy Code I

I have this data in my Customer table: 

CustomerID CustomerName
1          Steve
2          Andy
3          Brian
4          Allen
5          Devin
I 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