declare @DateFrom DateTime ='2012-07-15',
@DateTo DateTime = '2012-08-05'
;WITH CTE(totaldays)
AS
(
Select @DateFrom
Union All
Select DATEADD(d,1,totaldays)FROM CTE
Where totaldays<@DateTo
)
select count(1) from CTE
where DATENAME(dw,totaldays)In('Sunday')
declare @DateFrom DateTime ='2012-07-15',
@DateTo DateTime = '2012-08-05'
;WITH CTE(totaldays)
AS
(
Select @DateFrom
Union All
Select DATEADD(d,1,totaldays)FROM CTE
Where totaldays<@DateTo
)
select totaldays from CTE
where DATENAME(dw,totaldays)In('Sunday')