Yes and no.

There are procedures that use temporary tables and at the end throw out a string used by EF for another process.

Is there somewhere in EF that will tell...

I was able to get it by adding the following to the CASE:

And cd.ClaimsDateClosed between wq.StartDate and dateadd(q,1,wq.StartDate)

Also the longest warranties we offer is 7 years so...

That's great...

How about if there is an explicit expiry date set?

So an example would be for Warranty1 effective date is 2016-11-21 and expirydate is 2021-11-21.

So it would need 5 years...

Here's some sample data.

DECLARE @Warranty TABLE (WarrantyId int, EffectiveDate Date)
DECLARE @Claims TABLE (WarrantyId int, ClaimDate Date)

INSERT INTO @Warranty VALUES (1,'2016-11-21'),(2,'2017-01-04'),(3,'2017-05-13'),(4,'2018-10-28')
INSERT INTO @Claims VALUES (1,'2016-12-08'),(1,'2017-9-24'),(1,'2018-03-06'),(2,'2018-06-03'),(2,'2018-06-21'),(2,'2018-07-11'),(2,'2019-02-16'),(2,'2019-10-12'),(4,'2018-11-02'),(4,'2019-5-30')

I'd like to show...

I think you're right.

That column has a ton of special characters.  Might just abandon this and put a link to the main report in the email that they can drill...

I agree.
Loaded the 2005 database into the 2012 instance.
Ran updatestats with full scan on 2012 instance.
tempdb filled up.  (capped at 100GB)
For shi$s and giggles I set...

Sorry I didn't get a chance to update but I've managed to resolve the issue.
This was fixed by creating stats on the new database for every table and then...

Worked great.

Added DISTINCT to remove the duplicates but this is what I was after.

Thanks.

Perfect.

Thank you so much.

Even better.

Thanks!!

Got it. So simple when you step away from it for 30 minutes.

Was making this so difficult:

select td1.StepName

from testdata td1

where td1.stepname in (select stepname from testdata where...

Got it:

with cte as

(

SELECT Database, MONTH(Date) AS Month, max(Size) AS Size

FROM DatabaseSize_Archive

WHERE Server = 'CS1'

GROUP BY MONTH(Date)

)

SELECT Month, SUM(Size)

FROM cte

GROUP BY Month

ORDER BY Month DESC

This works great.

I'm going to add a growth calculation column but this is exactly what I was looking for.

Thank You.

Excellent solutions.

This is just a small part of the massive procedure I am currently modifying but performance of this piece has improved.

Thanks all.

The parameters are drop down lists populated by 2 seperate datasets that the user cannot edit.