Thanks Bayer 🙂 for providing such a good script which serve my purpose.

I modified little get the week number and week number for the month.

DATEPART(WEEK,Day(DATEADD(DD, (N - 1), @StartDate))) as...