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,402 reads

If you haven’t already signed up, on November 29, 2023, at 11 AM Eastern...

Picture this, you’re happily backing up your database to a Azure blob storage until...

I had a customer recently ask if SQL Compare could show them the differences...

hi xyz.bat this is called from microsoft sheduler. the contenct of .bat is followng....

Hello, our users are complaining about blocking during a delete loop so I'm thinking...

Hi, I've got an issue on SSRS where I have a daily subscription that...