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
Subscribe to:
Post Comments (Atom)
Passwords Made Easy
Today i thought i would write about password security. As we are all aware passwords are important but we continue to use very poor password...
-
Crystal Reports datepart is slightly different than SQL and VB Interval type Description yyyy Extr...
-
If DCOB Fault comes on your main phone this means that there is no external lines available and you will need to call you service pro...
-
If you have a situation that requires an application to always be up then try Restart program after a crash downloadable from https://w-s...
No comments:
Post a Comment