Thanks, this is corrected.

There is no easy way to put down all the backlogged items here. It's too many to organize and track.

We haven't triaged and assigned dates to everything. That would eat...

Put these as two steps in the same job.

Nope, looks like a caching issue. I see things marked from previous days, but if I answer today's, it's still shown as unanswered.

Filing a bug.

Maybe not the best query, but here's a test. Query embedded in the --ACT section.

CREATE OR ALTER PROCEDURE tsqltests.[test calendarsales]
AS
BEGIN
    ---------------
   ...

This isn't a question on whether to upgrade. If you've made the...

We have a few articles on calendar tables as well: https://www.sqlservercentral.com/search/calendar+table

I noticed you mentioned this is the 15th week, but didn't include that in the output. Is that correct?

Yeah, that was a typo, but too late to catch it in the newsletter. 🙁

Does support become a consideration?

How can MS help? By prodding the lazy vendors to support newer versions. We are held back by vendors who in some cases are recommending 2008! And these aren't...

For me it all boils down to costs.  Any change in licensing comes under the category of "difficult conversation". The costs in terms of time and effort to upgrade...

We do not allow this on the site. You should study the topics to pass the exam.

Closing this topic.

Talking of the new interface, the only way I seem to be able to get back to the list of questions is to click on QotD in the menu...

Yes

Also, does the row number get populated? Without that, you can't tell where the columns are. Rows have no natural order.

This can probably be done in T-SQL, though how do...