Looks like tempdb is mostly used for huge cache data sets of hash joins, Cartesian product joins, and sorting in tempdb.

Sorting usually happens in tempdb when there is no memory...

The script is attached to the Part 2 of the article mentioned in my 1st reply here.

AgeC alculation function

The script is attached to the Part 2 of the article mentioned in my 1st reply here.

AgeC alculation function

The script is attached to the Part 2 of the article mentioned in my 1st reply here.

AgeC alculation function

The script is attached to the Part 2 of the article mentioned in my 1st reply here.

AgeC alculation function

The script is attached to the Part 2 of the article mentioned in my 1st reply here.

AgeC alculation function

Adelia, what are you're struggling with?

You've been given a function which gives you all the right numbers, all you need is to incorporate those numbers into a string of the...

This seems to be awfully over-complicated.

This is much shorter:

SELECT CustomerID, 
CASE WHEN SUM(Cost1 + Cost2 + Cost3 + NewCost4) > 0 THEN 'Y' ELSE 'N' END AS...

Your multiple views use the same tables over and over again.

For example, table [Lease] is mentioned in your query plan 20 times, [User_area] - 21 times.

I did not bother counting...

SELECT *, 
CASE WHEN Days > 0 then convert(varchar(10), Days) + ' Days, ' ELSE '' END
+ CASE WHEN Hours > 0 then convert(varchar(10), Hours) + '...

This should show you how:

Article on age/duration calculation

If my assumption is correct, then there is a solution.

1st - let's find the latest eff_dt for each customer which is not continuous with a previous subscription period:

This reply was modified 5 years, 2 months ago by Sergiy.