Developping for the translation industry RSS 2.0



 Thursday, 10 July 2008

There is a very simple script to accomplish this and this can be really helpful for generating stats on a week-by-week basis:

SELECT DATEADD(wk, DATEDIFF(wk, 0, GetDate()), 0)

Replace GetDate with a datetime column and you could generate, for example, a sales report, week-by-week.

Thursday, 10 July 2008 12:25:54 (Eastern Standard Time, UTC-05:00)  #    Comments [0] -
Code Snippet | SQL

Navigation
Advertisement
About the author/Disclaimer

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

© Copyright 2017
Stanislas Biron
Sign In
Statistics
Total Posts: 135
This Year: 0
This Month: 0
This Week: 0
Comments: 1
All Content © 2017, Stanislas Biron