Select Page

Author: Steven Alexander

Rounding Error

Some people use the term “rounding error” to indicate that an answer is right enough, although not perfectly right.  Those people think “accurate” and “precise” are two different concepts. ...

Read More

The Rewrite And The Bug Fix

Last week I worked on two SQR program bugs.  I rewrote the first one from scratch.  I wanted to rewrite the second one but didn’t.  Here is why. The Rewrite My organization has an in-house timecard system.  After the...

Read More

Avoid Subqueries

I have nothing against subqueries, but there are times in the Peoplesoft environment that they are unnecessary.  If we can get exactly the same results with simpler, faster SQL, let’s avoid subqueries. PS_EMPLOYEES...

Read More