Generating a Distinct Delimited List Using XML
Generating an ordered, distinct, delimited string using ROW_NUMBER() and FOR XML PATH.
2010-06-29
8,712 reads
Puja Shah
Blogs
Synapse Analytics Spark Example 2 - ROW_NUMBER()
By Ed Elliott
The next example is how to do a ROW_NUMBER(), my favourite window function. T-SQL SELECT...
Synapse Analytics Spark Example 1 - Group By
By Ed Elliott
I have been playing around with the new Azure Synapse Analytics, and I realised...
Renaming Files by Padding Numbers with PowerShell
By Steve Jones
Some time ago I had downloaded all the SQL Saturday XML files. I’ve been...
Forums
The media family on device incorrectly formed for read only file group restore
Yes the databases (source and destination) are the same version. I have checked 3...
The Time Zone Range
Comments posted to this topic are about the item The Time Zone Range
Mathematicians and SQL
Comments posted to this topic are about the item Mathematicians and SQL
Ask SSC