http://pastebin.com/FXp13168

--update actuation_rule_tag set art_state = 2

--select art.* , t.tag_name,ar.* , u.unt_id , u.unt_name,u.unt_serial

--from actuation_rule_tag art
--inner join actuation_rule ar on ar.ar_id = art.ar_id
--inner join tag t on art.tag_id = t.tag_id
--inner join unit u on t.unt_id = u.unt_id
--where u.unt_id = 6 and ar_date is null
--and  (
--(ar_time >= '23:00:00' and ar_time < '23:59:59') or
--(ar_time >= '00:00:00' and ar_time <= '11:00:00') )
--order by u.unt_id,t.tag_id, ar_time

exec [iEnergy3BCP].[dbo].[GetUnitsForNextActuations] 60
exec [iEnergy3BCP].[dbo].GetUnitNextActuations 61,16
exec [iEnergy3BCP].[dbo].GetUnitNextActuations 5,16