OK. One simplified solution would be as follows:

1. Assume SessionDate is always the first of the month (so 2020-01-01 in my example above).
2. Calculate the number of days between the...

What do you mean by this?

If StartDate was 2018-12-31 and SessionDate was 2020_01, what would be your desired answer as the number of years between the two?

Possibly, but without knowing what dbo.fnGetSeconds does, we can't help much.

Well done with posting consumable data.

Can you also post desired results, based on your sample data?

Like Joe and many others here, I am averse to opening spreadsheets from untrusted sources....

He's called Brian! And the advice he has provided is sound: if the ETL solution is provided by a third party and there are...

With >1,700 points, you should know better. As already requested by others, please post consumable DDL, sample data in the form of INSERT statements and desired results based on your...

Untested, but something like this. Use a CTE to pre-aggregate the values in Cost Breakdown and then JOIN to that from Sales Line.

With Cost_Breakdown_Totals as 
(SELECT cb.sl_entry_no,...

Hi Des

thanks for the answer it works well except for values which are zero then it doesn’t list them. how to list the zero values?

For example if I include...

If you provide the following, there is a chance that you will get useful assistance. Without it, there's not much we can say.

1. DDL for the tables involved in the...

Ok, how about

TempAtMaxConductivity = temp

?

I imagine that if you replace this

CASE WHEN TagName = 'WFI_LP01_Temp.PV' THEN value END AS TempAtMaxConductivity

with this

TempAtMaxConductivity = value

it will solve the problem.

If you are referring to my code, that's called a SEMI JOIN and is...

Untested, but should get you closer.

select c.FirstName
from dbo.customers c
where not exists (select 1 from dbo.orders o where o.cust_id = c.id and o.order_date BETWEEN '20190201' AND '20190301')

Change your ORDER BY clause to use numeric (rather than alphabetic) ordering:

ORDER BY (x.ComToTal + y.Totals) DESC