Hi,

Try below script. It will loop through weeks between given dates and produce the output as you posted earlier.

SET DATEFIRST 1

DECLARE @weekDays TABLE (

UniqId int IDENTITY(1,1)

, StartDay datetime

, EndDay datetime

,...