It's really quite straightforward

Where X and Y are the two values from your results (OS.RecordCount and INS.RecordCount respectively ) use the following formula (a simplified version of your own):

(y-x/y)*100

In your...

I generally dislike DACPAC, but this might be a great use...

Which solution? And why?

What have you tried?

*reply deleted*

Have you tried in an incognito window, or another browser?

Faster

Without the additional info we can only guess at your full reqirements.

My first 'guess' is as follows

CREATE TABLE #T (Type CHAR(1),Year INT, MOnth CHAR(3), Car VARCHAR(50), Amount...

Hi,

You will need to you provide some further information before anyone can help you with your problem.

Include at least the following:

i. DDL For the tables in question.

ii. Readily consumable data...

• This reply was modified 5 years, 3 months ago by  nigel..
• This reply was modified 5 years, 3 months ago by  nigel.. Reason: fix typo

It looks like it's obecting to the pipe symbol ( | ) in that command line.

You may have to do it in more than 1 step ie. redirect the output...

Ahah! Users ( ******!!) who needs 'em ? 🙂

• This reply was modified 5 years, 6 months ago by  nigel.. Reason: Smile!

Which was .... ?

Why do you think your results are wrong ?

Your where clause clearly states that you want all rows with an END_DATE greater than 1st Jan 2019.

And any date in the...

• This reply was modified 5 years, 6 months ago by  nigel..

Ah, yes of course. Doh! 🙂

The calc I suggested will give you an offset in quarters from the 'DateKey' , so:

0 = current quarter

-1 = Previous quarter

1=Next

etc.

(Hint: try it in a select statement just to...

Try doing  something with this :

DATEDIFF(MONTH,0,c.DateKey)/3 - DATEDIFF(MONTH,0,@TodaysDate)/3