Sql Query Problem in sql server 2008

declare @d1 datetime,
	 @d2 datetime , @friday int
select @d1 = '2012-11-01',@d2= '2012-11-18' ;
with dates ( date )
as
(
select @d1
union all
select dateadd(d,1,date)
from dates
where date < @d2) select @friday= COUNT(date) from dates
  where datename(dw,date) = 'Friday'
 select  COUNT(*) as HolyDay  from HolyDaySetup where FromDate between '2012-11-01' and '2012-11-18'
 Declare @holiday int ,@monthDay int
 select @holiday= COUNT(*)  from HolyDaySetup where FromDate between '2012-11-01' and '2012-11-18'
select @monthDay= DATEDIFF(day,@d1,@d2)+1 
Select @monthDay -( @holiday + @friday) As WorkingDay

SELECT Friday, HoliDay , Month, and WorkingDay ..... Where between '2012-11-01' and '2012-11-18'.