SQR Dates
Numbers are probably the most important scalar objects of business applications, but dates may be a close second. Dates Are Harder Than Numbers Numbers are simple; they line up. Commands manipulate them without units. Dates...
All
Top RatedBad SQL Redesigned
The Assignment Last week we looked at various techniques for combining tables. As an example, we took an assignment “to gather the hours reported on timecards for each employee over a two week pay period.” We saw...
All
LatestSQL for Breaks in a Sequence
In a previous post, Views You Can Use: Ordinal Numbers, we discussed how to acknowledge children who visited Pee Wee Bees most often. The little boy who had been here the most (88 times to date) should be in first place. The...
SQL for Breaks in a Sequence
In a previous post, Views You Can Use: Ordinal Numbers, we discussed how to acknowledge children who visited Pee Wee Bees most often. The little boy who had been here the most (88 times to date) should be in first place. The...
Read More13 Peoplesoft Resolutions for 2013
Happy New Year! I resolved to take out the garbage for pickup on January 2. Mission accomplished. Now that you have quit smoking and lost weight, it’s time to work on some real challenges for professional self-improvement. Here...
Read MoreViews You Can Use: Ordinal Numbers
Cardinals and Ordinals As a child, I learned about cardinal and ordinal numbers. I just checked Wikipedia and found that my understanding of them is … childlike. I remember cardinal numbers as non-negative integers; 0, 1, 2, 3,...
Read MoreDate Arithmetic Breaks the Laws Of Arithmetic
One of our readers, John, recently posted a question on the SQR Dates blog entry: “I need to subtract from date in the format years, months, days. For example, I want to subtract 5 years, 2 months and 3 days from the current...
Read MoreThe Bug in Every Peoplesoft SQR Program
I shouldn’t claim that this bug appears in every SQR program written for the Peoplesoft environment. It’s not even in every SQR program that takes run control parameters. But I bet it is in most of them. The Peoplesoft Process...
Read MoreAnother Special Announcement
Please come back on Tuesday, October 18, 2011 for an exciting announcement. I am changing jobs again, and changing careers. I have spent the last 18 months working for a consulting firm, applying my PeopleSoft and SQR skills to...
Read More
Recent Comments