SQL Consulting

Welcome to r937.com, the Web site of Rudy Limeback, SQL consultant, Toronto, Canada.

Here you will find articles, commentary, and links to resources about SQL, writing SQL queries, and database design.

If you're looking for quality SQL consulting services at reasonable rates, please contact me for a free estimate.

Simply SQL

In December 2008, SitePoint published my book Simply SQL. For more information, please visit Simply SQL - The Web Site.

Latest Ask the Expert SQL answers

Note: links go to TechTarget.com; site registration might be required, but it's free.

How to check SQL query construction with the Mimer Validator
9 April, 2009
Using the SQL GROUP BY clause for counting combinations
9 April, 2009
How to use an SQL CASE expression
9 April, 2009

The full list of 686 SQL answers is on my Ask The Expert page.

Home
- About
- Site Map
- Services
  - Payments
- Contact
SQL
- Articles
- Ask the Expert
- DMXzone
- Links
Web
- Articles
- Links

The idea is that when the customer makes an order your store has entered in an agreement to sell something at a particular price. That price is stored on the order and is now a fact about that order. It is not redundant because you are not storing the SKU's generic price, you are only storing the price that that customer is going to pay on this order.

— The Database Programmer

SQL Consulting