sql start of week date code example

Example 1: sql week commencing date

DATEADD(dd, -(DATEPART(dw, [Date])-1), [Date])

Example 2: sql server week number

datepart(wk, DateToParse)