tmp.sql

SET NOCOUNT ON

DECLARE @Starts DATETIME
DECLARE @Ends	DATETIME

SET @Starts = '2014-06-05 00:00:00'
SET @Ends	= '2014-06-05 23:59:00'

select
	ROW_NUMBER() OVER (PARTITION BY DayId, ResourceId ORDER BY DayId, ResourceId)
	- ROW_NUMBER() OVER (PARTITION BY DayId, ResourceId, DATEPART(Hour, ActualStart) ORDER BY DayId, ResourceId, DATEPART(Hour, ActualStart)) AS groupId
	,*
from servicetime
where 
	(Actualstart >= @Starts AND ActualEnd <= @Ends)
AND	(Closed = 0 OR DenyBooking = 0)