We're spinning our wheels because we don't know enough about your code or the underlying tables.  You even have an error in the FROM clause of the code in your...

I wonder if this is based a bit on old pre-2005 wives' tales that possibly used to be true and a bit on the 5 Monkeys Syndrome or maybe on...

You simply do your best. If you are not allowed...

Aren't those supposed to be backslashes instead of forward slashes?  Could that be the remaining issue?

You might want to look into partitioning.  If I had it to do over again (I had a similar requirement), I'd have used a Partitioned VIEW instead of a Partitioned...

This is fun code to test and try to get ones head around - in which orders are operators applied.

DECLARE @i INT=0;
UPDATE t SET @i =...

Ah... gotcha.  Thanks, Glenn.  I'll do my best over the weekend.

A SQL Server solution to this problem, without using mathematics, would be very interesting. This was a real problem that I worked on, and I expected to do some...

Ah... thanks.  I totally missed the link.

Thanks folks.  Still looking to find out if AWS RDS will support the Developers Edition or not.  I'd look for myself but I don't yet have access.

Just a quick comment re. DateAdd.  I just got myself into trouble with a DateAdd function that was adding 1 year to 2/28/2019.  The application was working with budgets...

Shifting gears a bit... does AWS RDS support the Developers Edition of SQL Server?  Also, any idea if they support 2019 yet?

Ah... and in the absence of a more defining problem, given a year number, create one file per ISO week that contains all columns of each row in the week...

One of you folks that knows how to use SSIS should write an article on this... it would be a popular one because a lot of people need to do...

We have template Python projects so that the start of any Python development has a big head start

<li style="list-style-type: none;">

• Virtual environment build (venv)

<li style="list-style-type: none;">

• Test...