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 3 years, 3 months ago by  Sergiy.