SELECT CONVERT(char(10),DateAdd(day,number,'"+beginTime+"'),120) days,
datename(dw,CONVERT(char(10),DateAdd(day,number,'"+beginTime+"'),120)) weeks
FROM master..spt_values WHERE type = 'p'
AND number <= DateDiff(day,'"+beginTime+"','"+endTime+"')
SELECT CONVERT(char(10),DateAdd(day,number,'"+beginTime+"'),120) days,
datename(dw,CONVERT(char(10),DateAdd(day,number,'"+beginTime+"'),120)) weeks
FROM master..spt_values WHERE type = 'p'
AND number <= DateDiff(day,'"+beginTime+"','"+endTime+"')