declare @dt1 datetime,@dt2 datetime,@i int
set @dt1 = '2010-2-23 23:00:00'
set @dt2 = '2010-2-28 14:21:00'
set @i = 1
declare @t table(dt datetime,l int)
while dateadd(d,@i,@dt1)<@dt2
begin
insert @t select dateadd(d,@i,@dt1),case when datepart(dw,dateadd(d,@i,@dt1)) in(1,7) then 0 else 24*60 end
set @i = @i +1
end
insert @t select @dt1,case when datepart(dw, @dt1 ) in(1,7) then 0 else datediff(mi,@dt1,convert(char(10),dateadd(d,1,@dt1),120)) end
insert @t select @dt2,case when datepart(dw, @dt2 ) in(1,7) then 0 else datediff(mi,convert(char(10),@dt2,120),@dt2) end
select sum(l) as m from @t