I believe you want decimal(4, 1) rather than (3, 1) (at least I can't see any reason why 100% of one...

Heh... right after I posted above, I got an email from GROUPBY.Org that the schedule has been published.  There are two tracks for the Americas on May 24th and two...

My "Black Arts" Index Maintenance 1.2 presentation was selected on GroupBy.Org for May 24th, 2022.  I don't know if my "ask" above had anything to do with that but I...

First of all, you didn't actually post the error you're getting.

Second, what are the datatypes for all of the columns involved"?  That's actually super important to know here.

Here's another way to post "Readily Consumable Date" followed by a different solution that uses the SUM() Windowing Function.

Here's the test data construction...

--===== Create the test table...

The #t that Phil is using is what you should...

What is the primary key on these tables?  And, are you really using 2019?  If not, what version?

Did you look?

https://www.google.com/search?q=downgrade+sql+server+enterprise+edition+to+standard+edition

What size is your largest index, what Recovery Model are your databases in, and what, if any, index maintenance do you do?

You bet... thank you for the feedback.  It also has one of the (IMHO) better SQL Tutorials (Not to mention the HTML and other...

Thanks for the feedback on that, Phil.  I LOVE that site. T It also has one of the better beginner SQL...

Instead of making us go back an unknown number of...

I try to avoid the RGB notation because it makes troubleshooting a whole lot more difficult.  If you go to the following link...

https://www.w3schools.com/tags/ref_colornames.asp

... and do a search for the #90EE90...

Ok... no actual data.  Moving on.  Good luck. 😉

How about it @Smash125?  Why do you need this top be done?