DECLARE @rtDayofWeek VARCHAR(10)
DECLARE @dtDate datetime
DECLARE @endDate datetime
SET @dtDate = '8/25/2010'
SET @endDate = '8/27/2010'
WHILE @dtDate <= @endDate
BEGIN
SELECT @rtDayofWeek = CASE DATEPART(weekday,@dtDate)
WHEN 1 THEN 'Sunday'
WHEN 2 THEN 'Monday'
WHEN 3 THEN 'Tuesday'
WHEN 4 THEN 'Wednesday'
WHEN 5 THEN 'Thursday'
WHEN 6 THEN 'Friday'
WHEN 7 THEN 'Saturday'
END
PRINT @rtDayofWeek
SET @dtDate = DATEADD(Day,1,@dtDate)
END

Hope this helps buddy :D

None :D