Query para horas habiles

[pabg0922]

ok. sip... que descuido....
mira tengo este codigo para los holidays

declare @company int = 1
declare @fch_ini date = '2012-12-01'
declare @fch_fna date = '2012-12-07'

declare @habiles int
declare @laborales int
declare @holidays int

set @holidays =( select count(*)
from GEN_Holidays
where intCompanyID = @company
and charDescription <>'Sabado'
and charDescription <>'Domingo'
and dtDate between @fch_ini and @fch_fna)
set @habiles = DATEDIFF (DD,@fch_ini,@fch_fna)+1}
set
set @laborales = @habiles - @holidays

---- tengo esta otra consulta que me genera los habiles sin sabados ni domingos----
----cree una tabla temporal para guardar esto----

declare @fch_ini datetime = '2012-10-01'
declare @fch_fna datetime = '2012-10-31'
declare @company int =1

Insert #Dias (nombre, Total) select charDayName as Day, count(*)as Total
FROM CalendarCountry WHERE intCompanyID = @company
AND date BETWEEN @fch_ini AND @fch_fna
and charDayName <> 'Sábado'
and charDayName <> 'Domingo'
group by charDayName

----------------------------tengo este otro query pra que me calcule la diferencia de horas

eclare @FISAP DATETIME = '2012-12-01 08:00:00'
declare @FFSAP DATETIME = '2012-12-01 10:30:00'
declare @ok varchar

set @ok = CAST(CAST((DATEDIFF(MINUTE,0, @FFSAP) -
DATEDIFF(MINUTE,0, @FISAP))/60.00 AS DECIMAL(9,6)) AS VARCHAR)
print @ok

------

Y pues como pueden ver... estoy muy envolatada....

Muchas Gracias...