You're right.  I misread the question.

Since there's no readily consumable data that we can copy and paste from (see the article at the first link in my signature line below...

Hello Jeff,

Sorry for that and got your point, I am using - Microsoft SQL Server 2017. Please fine the sample data in SQL format.

SELECT '-1010-----' AS...

Don't post graphics. ...

The data you posed has nothing to compare.

As a bit of a sidebar, I do nightly fulls and, depending on the server, transaction log backups er 15 to 30 minutes with a twist... I don't backup the...

Hi Steve, thanks but what you are providing here is calculating percentage. My ask is to get an average of 4 month percentage (or 5 or 6 month depending...

Heh... who said anything about using "cloud services"?  Not me. 😀

You could also use it as a learning opportunity by doing the research and then writing your own.

Rather than doing it for you, I was trying to inspire you to have another look.  You're provided some intelligent answers to my questions and you know the rules better...

Cool.  Peter answer the question.  Have a good night, folks.

For anyone interested, here's the cleaned up and modernized version of the DDL and test data.  Note that there is no IDENTITY column in this table.  Also note that the...

Pretty close but I can tell you didn't...

Hi,

Do we have to pay for  opening a support ticket with Microsoft for technical issues.

I am looking at things like Premier Support and Unified support on their site. Not...

For ZIP code, I strongly recommend NOT using VARCHAR.  Use CHAR instead.

My first observation is to ask if there's a 1:1 relationship between Customer # and Applicant?

My next question would...

I strongly recommend that you Read'n'Heed the article at the first link in my signature line below to help us help you.