Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
duhaas
Constraint Violating Yak Guru
310 Posts |
 Posted - 2007-05-22 : 17:09:50
|
| Somewhat new to SQL server and was hoping to use the F_TABLE_DATE function to help build a report where I could group by a date field, and group it weekly. Just not sure how to use that function, any examples or insight on how to accomplish this? An example of what I have now is5-10-07 --- 10005-11-07 --- 20005-12-07 --- 21115-13-07 --- 22225-14-07 and so onI want to group the total numbers weekly |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-05-22 : 18:58:58
|
| >> "group by a date field, and group it weekly."Which is it you want to do?It would be be good if you provided detailed infomation about what you are trying to do. Please follow the directions in this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxCODO ERGO SUM |
 |
|
|
|
|
|
F_TABLE_DATE