While Looping - SQL SERVER
DECLARE @StartDate AS DATE='2014-12-17'; DECLARE @EndDate AS DATE='2014-12-25'; CREATE TABLE #DateList(iDate DATE,iDayName VARCHAR(10)) WHILE (@StartDate<=@EndDate) BEGIN INSERT #DateList(iDate,iDayName) VALUES(@StartDate,DATENAME(DW,@StartDate)) SET @StartDate=CAST(DATEADD(DAY,1,@StartDate) AS DATE) END SELECT iDate AS [Date], iDayName AS [DayName] FROM #DateList