Get data in current week

Get  data for the current week in TSQL

The below is how to get the sum of something for a week

select sum(somthing) from atable  WHERE your_date  >= DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()) / 7 * 7, 0)
AND  your_date  <= DATEADD(DAY, DATEDIFF(DAY, -1, GETDATE()), 0)





You could also use

select* from atable  WHERE your_date  >= DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()) / 7 * 7, 0)
AND  your_date  <= DATEADD(DAY, DATEDIFF(DAY, -1, GETDATE()), 0)

to get all data for that week