Generate date for certain periods and Retrieve Excluding weekend

create table  #dates (dt datetime)   

DECLARE @dateFrom datetime

DECLARE @dateTo datetime

SET @dateFrom = '2013/09/29'

SET @dateTo = '2013/10/27'

WHILE(@dateFrom < @dateTo)

BEGIN

   SELECT @dateFrom = DATEADD(day, 1,@dateFrom)

   INSERT INTO #dates

   SELECT @dateFrom

END

SELECT * FROM #dates

SELECT dt

FROM #dates

WHERE DATEPART(dw, dt) NOT IN (1, 7);

select * from #a