insert #cnt_flm
(DwIDdayValue, cnt_flm)
select
 t.DwIDDayValue, count(distinct dd.extIdDevice) as cnt
from
 sa.sa_dayValuesTemp t
 inner join [sa].[sa_dayValuesPUOU] pu on pu.DwIDDayValue = t.DwIDDayValue
 inner join dbo.linkDeviceNodeAccount ldna on ldna.IntIDNodeAccount = pu.IntIDNodeAccount
 inner join dbo.device dd on dd.IntIDDevice = ldna.IntIDDevice
 inner join dbo.modelEq me on dd.IntIDModelEq = me.IntIDModelEq
where
 t.levelProcessingValidate = 1
 and not exists (select 1 from [sa].[sa_dayValuesErrorTemp] e where e.DwIDdayValue = t.DwIDdayValue and e.LevelError = 2 and e.TypeError = 1)
 and t.DateValues between ldna.fd and ldna.td
 and t.DateValues > ldna.dtStartLinkToNodeAccount
 and t.DateValues between dd.fd and dd.td
 and t.DateValues between me.fd and me.td
 and ldna.Activity = 1 
 and me.IntIDTypeEq = @IntIDFlowMeter
 and t.IntIDTypeEq = @IntIDTypeEqHeatCount
group by
 t.DwIDDayValue