XML is a different animal...

When did CROSS APPLY become the "not set based" approach?

-- sample table

DECLARE @demo TABLE

(

SomeID int identity, -- you need this to know the source of your XML

SomeXML XML

);

-- insert a couple xml values

INSERT @demo

VALUES...

Two year old thread but other languages such as PL/SQL, XSLT & SAS have a "translate" function which is a single-character "nested replace" function. This is one of those extremely...

You've written a very interesting function sir, very clever. That line above stood out to me. I don't know if you...

Perhaps it's a shot in the dark and I don't know anything about Sharepoint lists but, if you can write a stored proc that accesses the XML in a SQL...

The ability...

I'm with Jeff - sounds like your stats are not getting updated. You should check your Auto Update Statistics setting for your databases (right click DB, go to options).

Jeff Moden (4/10/2016)

---

Awesome. I don't very often see such a useful bit of header information. You've provided a succinct...

MadAdmin (4/26/2016)

---

What should the results for these test cases be?

SELECT age FROM dbo.YearsApart('2/28/2002','02/28/2003');

SELECT age FROM dbo.YearsApart('2/28/2003','02/28/2004');

SELECT age FROM dbo.YearsApart('2/29/2004','02/28/2005');

SELECT age FROM dbo.YearsApart('03/01/2004','03/01/2005');

Edit : Seems that how you handle leaplings depends...

Make sure not to use my solution (not my best work - but I was in a hurry). Both Jeff and Luis posted brilliant solutions. I...

Thanks PB_BI. After a little more analysis I discovered that it was in fact an issue related to stale metadata which was resolved by restarted the SSAS service.

This will get you there except when the first or last fields are NULL. I'll let you figure that out or perhaps someone else will jump in to seal the...

Great Editorial Steve!

That's going...

No need to use Pivot at all. Here's Robert's sample data in a temp table (using a temp table so I can show you how to index correctly for my...