Home arrow SQL arrow Page 6 - Lies, Damn Lies, Statistics, and SQL
SQL

Lies, Damn Lies, Statistics, and SQL


sqlHeard about the Developer Shed December Giveaway?  Peter has a method useful for all things statistical.  In this article, Peter shows us how you can make use of some quick methods to generate statistics for your sites or projects in as little time as possible.  Using MS Access and a little SQL code, Peter is able to devise an algorithm useful for determining this month's winner.

Author Info:
By: Peter Lavin
Rating: 3 stars3 stars3 stars3 stars3 stars / 23
December 23, 2003
TABLE OF CONTENTS:
  1. · Lies, Damn Lies, Statistics, and SQL
  2. · Finding the Data
  3. · Capturing the Data
  4. · Into the Database
  5. · The Contest SQL
  6. · Conclusion

print this article
SEARCH DEVARTICLES

Lies, Damn Lies, Statistics, and SQL - Conclusion
(Page 6 of 6 )

We were able to quickly retrieve data from the Dev Articles site and save it as a text file with tab-separated values. This enabled us to import the file into a table in Access. Querying this data using SQL statements allowed us to arrive at an objective determination of the December contest winner.

Finally, to the prize committee I would like to say ďThank you. Donít wrap it, Iím not putting it under the tree.Ē ;)


DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.

blog comments powered by Disqus
SQL ARTICLES

- Focusing SQL Queries
- Complex SQL Queries
- A Close Look at the SQL Query
- Generating Reports with SQL Date Handling
- Creating SQL Reports Based on Date Criteria
- SQL Date Handling and Data Trends
- Date Handling
- Introduction to SQL
- Lies, Damn Lies, Statistics, and SQL

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 
Support 

Developer Shed Affiliates

 




© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials