March 25, 1997

Calculating Averages Within Arbitrary Groups

Question: [Joe Celko’s Production Report Puzzle]We get a production report from work centers which has a date, center code and how many widgets were produced from each batch of raw

Nested Outer Joins

Question: [Joe Celko’s Outer (JOIN) Limits Puzzle]Gerard Manko at ARI had a problem in 1994 April. They had just switched over from Paradox to Watcom SQL. The conversion of the

What does AFX stand for?

Question: I see the term “AFX” everywhere in the MFC source code.For example, “AFX_MSG_MAP”. What does it mean? Answer: I once asked this of Jeff Harbers, one of the original