Puja Shah

Generating a Distinct Delimited List Using XML

Generating an ordered, distinct, delimited string using ROW_NUMBER() and FOR XML PATH.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.15 (20)

2010-06-29

9,667 reads

I was recently asked to review SQL Server Query Tuning and Optimization by Benjamin...

If you attended my talk at SQL Saturday Los Angeles 2022, then you can...

One of the things I did often in my first career job was create...

Comments posted to this topic are about the item How to use PowerShell to...

Hello everyone, Hi have this column named Sex and it only has value 0...

I have compared two tables with the same data in two different databases(aslo the...