I want my first day of the week to be as Sunday but my issue with my code is that it starts always as Monday.
DATEADD(DD,CONVERT(INT, (DATEDIFF(DD, '1/1/1900', t.DT)/7)) * 7,'1/1/1900') [WeekBeginDate],
SUM(HOURS) AS TOTAL_HOURS
DT >= DATEADD(WEEK, -6, GetDate())
UID, CONVERT(INT, DATEDIFF(DD, '1/1/1900', t.DT)/7)