end of week sql code example

Example: sql week commencing date

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