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

3 Types of SQR Variables in SQL Statements

SQR programs can execute SQL “select” statements with a “begin-select … end-select” block. They can execute any other SQL statements with a “begin-sql … end-sql” block. SQR has three ways to modify the literal text of those SQL...

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

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

Read More
Loading