Thanks again!

thanks so much .. it works perfectly!! Can you tell me, could the same thing be accomplished using a View instead of the CTE and then adding the Group by...

I think I have it working with the modified version below

WITH Summary (site_number, site_name, entity_equipment_name, timestamp, ActiveSetpoint, ZoneTemp)

AS

(

SELECT s.site_number, s.site_name, e.entity_equipment_name, DATEADD(MINUTE, DATEDIFF(MINUTE, 0, h.timestamp),0 ), (select numeric_value...

Thanks for the reply!

When I add the Group By I get the following error?

"Each GROUP BY expression must contain at least one column that is not an outer reference."

Ideas?

No, I just created the plan and saved it. Should...

Ok .. try this one. If this doesnt work, then I will just for the Actual Execution Plan and post later.

I am still running the query, its at 45min+ :-D.

I wanted to try the suggested index, but there is already one on the table very similar and our other...

Thanks for the quick replies guys! Sorry for confusion, I havent posted a question here before and wasnt entirely sure what you would though am not surprised to hear you...