Thank You! You saved me a ton of time.

Thanks. I am learning CTE and so it was helpful when you broke it down, but how do you put all this in one query?:-)

:-)Thanks. Here it is:

if (object_id('tempdb..#Astime') is not null) drop table #Astime

create table #Astime (ResourceId smallint, Site smallint,

DateKey int, TimeKey int, EventType smallint)

insert into #Astime

select 1, 1, 20100901, 80010,2

union

select...

Thank You!

Thanks!

Hi,

Now with a twist , I want to do same as before but update the TeamAverageHold time as a sum of Teams 1 and 2 :

...

Thanks it works!:)

Yes.

This does it without using a view:

SELECT ITS.ItemNumber, ITS.ItemName,ITS.StatusDetail,ITS.StatusDate

FROM MAIR_tblItemStatus ITS INNER JOIN

(SELECT MAX(ITS.StatusDate) AS MaxDate, ITS.ItemID

FROM MAIR_tblItemStatus ITS

GROUP BY ITS.ItemID) Sub

ON ITS.ItemID =...

Thanks!

Thank You!

That was quick and it works!

🙂