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)

You rated this post out of 5. Change rating

2010-06-29

10,303 reads

I’m heading to Boston next week for SQL Saturday Boston 2023. I went to...

We’ve been doing some events as part of the Redgate Roadshow, and at one...

As I have mentioned in prior blog posts, I have been writing a data...

Hi, This is my table and data, CREATE TABLE [dbo].[rpt_AR_StatementOfAcct_003]( [Id] [int] IDENTITY(1,1) NOT...

Some of our databases are getting be close to 2 terabytes. We are backing...

I'm working on a data analysis project in Python and need to calculate both...