If you're using 500GB now, it could be very hard to squeeze down to 128GB.

It's likely, however, that you are not using data compression now.  From SQL 2016 on,...

This can all be done in T-SQL pretty easily... we just need so reasonable data and task description to work with.

FK's to other databases also don't work in "normal" on-prem servers.  And, we don't need a separate post on this. 😉  We do need a bit of a better description,...

You cannot restore a 2019 database to a 2016 server even if you're in the 2016 compatibility mode on the 2019 server.

"Each record"?  Which table and could you please provide some test data for the data you want to report on?

All you've provided so far is a table with an IDENTITY...

You're still working on your Calendar table.  I'll be happy to show you how to do that but that's not the real issue.  The issue is, what do you want...

Getting back to the original issue, if you'd go back to the original thread that start all this and answer my simple question, you might get somewhere.

As for the question...

Ok... That was an important part for us to know there.  With that out of the way, we need to know a few things to be able to help you...

I work on sql server 2019 i have table have multi column string concatenation as StrSubstance,strmass ,strcasnumber

i need to create filed hashchemical with nvarchar(700) and this will store hash...

So please explain how the 1/1/2021 entry for sales of 100 gets knocked down to only 5 calls in the desired output.

To @ratbak's point about providing DDL, please see the...

p,s.  And, yes... I understand what you're trying to do and maybe even why.  I just need for you to answer my question about the ChemicalID nulls/non-nulls above.

Does the ChemicalHash table ONLY contain rows where the ChemicalID is NULL or does it have rows where the ChemicalID is not null?

This could be pretty easy but, I have to ask, why are you basing your reporting periods on 365*24/12 - 730 hours = 43,800 minutes = 30.4 days?  All that...

Heh... I was wondering what you used for a base date in your example. 😀

Totally agreed on the rest.  My current issue is that the increments are clicking by way...

Actually, you did...

Actually, the development team should have nothing to...