Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: perrygordon
- Order by date
-
help with grouping by dates
Thanks Bill. That is a good idea. I think in my situation it would be better to create the seperate table. My sales table has millions of records so that extra field would take up more space. If I go with the seperate table of dates and corresponding fiscal months, I would only need one record...- perrygordon
- Post #8
- Forum: SQL
-
help with grouping by dates
Thank you for the reply, but perhaps I was not clear. Maybe an example would help. Let's say I have a table of sales information. One record per day, and the number of sales for that day. If I group by DatePart month, I can see the total number of sales for the entire month. Like so ... SELECT...- perrygordon
- Post #6
- Forum: SQL
-
help with grouping by dates
I have a related question. Is there an easy way to group by financial month, such as Dec 22 - Jan 21, next group would be Jan 22 - March 21?- perrygordon
- Post #4
- Forum: SQL
