Join | Login | Why Join?   
SQL Server, Oracle, DB2, Sybase, MySQL Help - SSWUG.ORG HACKER SAFE certified sites prevent over 99.9% of hacker crime.
Search SSWUG:   
 
Access to 474 free guest articles, discussions and more, just create your free SSWUG User ID:
Email address:  
This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.
Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

Full site membership is required for this article. Already a full member? Login here.
You currently have a guest membership. You can upgrade to full site membership here (free trial available).

Use a Grouping Table To Optimized Date Based Queries


 Article Abstract:

(Ben Taylor) Many database systems contain data captured over a period of time. Frequently reports are produced that are intended to allow for statistical analysis of the activity, trends or maybe even an aggregation of the detail for data mining or executive reporting. As a result database programmers are frequently required to group data into one or more logical periods for reporting or data mining purposes. The number of grouping options possible are virtually limitless. In this case use a Grouping table.

 Read this article...
 Related Articles - For Members.
All Articles By Author

Optimize Reporting Services With a Filter Table
SQL Server query optimization by using hints
Rolling Window, Grouping Tables and More
SQL Server Query Analyzer Optimization Tips
Oracle's Enhanced Group By Clause Part 2
OLAP and Data Warehousing (OLAP clients - English Query)
Troubleshooting SQL Server Query Optimizer Problems
SQL Server 2005 Express Manager vs SQL Server 2000 Query Analyzer
What's Hot in Your Query Analyzer?



Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content

Reader Comments: Post Your Comments/Feedback

RE: Use a Grouping Table To Optimized Date Based Queries
by kevin horan (posted: 10/1/2006 10:31:25 AM)
excellent explanation and script what would have been better is if the grouping table could be dynamiclly populated based on the period availbe in the sales table.


Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

   



 

[ Register ] [ Webcasts ] [ Podcasts ] [ Newsletter Archive ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to SSWUG ] [ List Server Archives ] [ Recent Orig. Content ]
(c) 1997-2008, Bits on the Wire, Inc.  (0)

Some names and products covered by SSWUG are the registered trademarks of their respective owners.
DAA10354WWW004