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...

An I forgot. You can not like posts. There is a like link next to the date/time of a post

It was easiest to not rewrite. I personally think that's better as this isn't the thread, but a post.

It's possible, I think. Never thought about this, but I'll raise an issue to look at this. It's likely to be low priority, but an interesting idea.

A quote test:

SELECT *
FROM MyTable
WHERE ID = 1
AND Name = 'Thom'
AND Status !='';

Fingers crossed