Generating a Distinct Delimited List Using XML
Generating an ordered, distinct, delimited string using ROW_NUMBER() and FOR XML PATH.
2010-06-29
10,301 reads
Generating an ordered, distinct, delimited string using ROW_NUMBER() and FOR XML PATH.
2010-06-29
10,301 reads
By Steve Jones
We’ve been doing some events as part of the Redgate Roadshow, and at one...
By James Serra
As I have mentioned in prior blog posts, I have been writing a data...
By alevyinroc
I’m happy to announce that I will be speaking at SQL Saturday Boston on...
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...