OR something like this
declare @StartDate datetime = '2010-11-22'
declare @EndDate datetime = '2010-12-22'
;with DateSequence
as
(
select @StartDate Date
union all
select Date+1 from DateSequence where Date<@EndDate
)
select *,datename(WEEKDAY,Date)Day from DateSequence
order by datepart(WEEKDAY,Date)
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server