Hi,

i midst to searching for this function

create function overlaphours(@s1 as datetime,@f1 as datetime,@s2 as datetime,@f2 as datetime) returns integer as

begin

declare @result as int

set @result=0

if @s2>=@s1 and @f2<=@f1

...