CREATE FUNCTION dbo.funcGetHour (@fromDate datetime,@toDate datetime)
RETURNS int
AS BEGIN
declare @Hourss int
set @Hourss=0
WHILE (@fromDate <@toDate)
BEGIN
if(datename(dw,@fromDate)<>'Saturday' and datename(dw,@fromDate)<>'Sunday')
Begin
set @Hourss =@Hourss+1
--print @Hourss
--print datename(dw,@fromDate)
--print @fromDate
End
set @fromDate= dateAdd(hour,1,@fromDate)
END
RETURN @Hourss
END