Building Better SQL Queries
By Mo Budlong, January 01, 2003
In an awkwardly designed database, building SQL statements can be troublesome. The CSQL Class presented here builds a correctly formatted query from parameters entered one piece at a time, resulting in simple, easy-to-read SQL queries.
Building Better SQL Queries
Listing 7 An example insert query generated by CSQL
INSERT INTO
DeptTotals
(
year
, week
, dept_id
, revenue
)SELECT
dd.year
, dd.week
, dd.dept_id
, SUM(dd.revenue)
FROM
DeptDaily dd
WHERE
dd.year = 2002
AND dd.week = 47
GROUP BY
dd.year
, dd.week
, dd.dept_id