Oh lordy... I posted before having enough coffee.  This is...

Instead of having multiple connections trying to delete one or two rows at a time from all over hell's little half acre in the table, remember that it's a TEMPORAL...

Shifting gears to another aspect to employment, I'd say "and so it begins" except that it's been this way for a long time.  It's just getting worse.  If you have...

Heh... ah... I know what you mean now.  No comment. 😉

I "love" some of the ads I've seen... they start with needing only 2 years of experience but want a full stack developer that is also an expert...

My pleasure and thank you for the feedback.  xp_LoginInfo is one of those tools that I don't need to use often but it's a real life saver when I do...

He is not a member of sysadmin role.

He is in one group, but it has read only and that is it.

It must be something that carried over from the...

What are you trying to do??? Get just the rows with the highest TotalDue for each BusinessEntityId ???  I so, just change the ASC in your ROW_NUMBER() to DESC and...

Hello ,

I have an SQL server installed in the 'Enterprise Evaluation Edition' the server has expired I have exceeded the 180evaluation day

and despite this overrun my instance continues to...

You might want to take a look at the execution plan for that.  With just the 9 rows of data the OP posted, it does 48 table scans...

Disregard my previous from this post if you end up seeing it in your email.  I did some bad math.  The 432 rows are completely necessary.

Here is an alternate version

   With accountData
     As (
 Select Distinct
        td.[Year]
 ...

Heh... ok.  Been there and done that... That's how it always starts. 😀

The other thing is that someone that gets desperate for some code on something much larger, might end...

If you want help on this, and there are a large number of people that can help with this on this forum, you're going to have to provide more information...

And the second article describes how to do it...