Select Page

# All

Popular

## 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 Rated

## Hooray For Arrays.Part(1)

I’ve mentioned arrays while writing about other topics.  It’s time I write about arrays.  Someone could program in SQR for a whole career without ever using them, but that someone would have to work harder to do...

# All

Latest

## 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...

## 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...

## 13 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...

## Views 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,...

## Date 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...

## The 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...

## Another 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...