
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

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

Question: [Joe Celko’s Best Salesmen by Territory Puzzle]Martin Tillinger posted this problem on the MSAccess forum of CompuServe. How do you get the top three salesmen in each territory, given

Question: What is the difference between VRML 1.0 and 2.0? Answer: VRML 1.0 worlds are static environments in which you can move around and click on objects to link to

Question: How can I achieve photographic 3D environments on the Web? Answer: QTVR is a type of movie file format that enables users to navigate photo-quality scenes. There is a

Question: Is there software out there that allows one to create interactive VRML worlds without knowing how to program? Answer: Yes: Fountain Pro from Caligari, Virtual Home Space Builder from

Question: I’ve heard a lot about VRML, but don’t know what it is. Please explain. Answer: VRML (Virtual Reality Markup Language) is a method for sending 3D data across the

Question: I’m wondering if/how one can link two or more embedded VRML objects in a single Web page so that both objects would respond to the same key/mouse input. I’m

Question: Someone told me I have to specify a MIME encoding somewhere on my server. Would you be kind enough to tell me where on a Windows NT server Internet

Question: What are the disadvantages of ODBC versus SQL? Answer: ODBC is a generic implementation, whereas native SQL is always optimized for the database server being used. Thus, if you