I added 1000 "sets" of 3 groups, each with 13 dates.  The Cartesian products persisted in the execution plan, each of them doing reads of 39,078,039 rows.

Too bad because, like...

That certainly solves the problem without an explicit WHILE loop or a "Quirky Update".  I used the following  code the add 5 more sets of 3 groups each to "play"...

This is a delayed message as I...

my attempt at this.

Do note that the 5 days interval is partially misleading as to the final result because of the time part.

,(7 ,'2017-11-17 09:38:00.000') --Group 2 starts here...

Here's the solution to the problem you posted.

 SELECT CSV = STRING_AGG(sal,',')
   FROM #emp
;

There are more powerful uses for the STRING_AGG() function if you have...

Do you understand what it does and how...

If you mean add some relational stuff to the WP document store, I'm tempted. I think...

To be absolutely clear, you want a:

2) unique clustered [index] on (tenant,year,id)

And if you partition the data (which typically wouldn't be necessary here), partition it by (tenant, year) not...

Thanks, Steve.

I've logged quite a few bugs lately on things. We've got a test site setup for an upgrade to PHP/WP/Nami, which is delaying work on other bugs. The upgrade...

Bloody forum software did it again... since the post I just posted is the first one on a new page, it's not showing up until I make another post.  I...

I show an example in the query tuning book where defragmentation improves performance because of a scan, fewer pages read. I also explain all the reasons why, this probably...

Thanks, Greg.  I have to admit I took it wrong way a bit and so was just making sure.  And I love both of your examples.

As a bit of a...

Thanks for the "faith" and thank you for the incredible feedback..  Our buddy, Ed, did the same thing with similar results after I told him what I'd found, especially concerning...

You do realize that your graphic has the S1SDat column listed 3 times, right?  Is there a similar problem with the rest of the code that you've not displayed?

Also, do...