This would work if you always have contiguous dates. Otherwise, you might need an additional ROW_NUMBER function.

WITH CTE AS(
  SELECT *, DATEDIFF(dd, ROW_NUMBER() OVER (PARTITION...

Thank you for taking the time to write the article. I found out about this option last year when Aaron Bertrand wrote about it. If someone wants to read more...

I'm curious. Who would read a row like that? What is this good for?
There's a good reason for people in Microsoft not trying to deliver a wider row. It's...

You could post a profile at some freelance sites. You should also, at least, post a link to your LinkedIn profile, personal site/blog, or some other place to show your...

Probably something like this?

WITH CTE AS(
  SELECT
   CASE
    WHEN EntityType = 'A' THEN DataPoint1
    WHEN EntityType = 'B'...

This solution is untested and might not even solve the problem. It's using what should be generic SQL (except for the variables).
The lenght of the code is not the...

--Deleted post