I'm just hoping that Microsoft will get around to implementing the ANSI/ISO standard null first or last subclause that goes after the sorting direction. Since it applies column by column,...

The case expression returns a value of a particular data type. In your example, you're sorting on a numeric, without regard to what the original column was. This would seem...

The ANSI/ISO standards specify an extra clause that goes after the order of the sort (ASC | DESC) which will let you decide the order of the nulls within that...

You missed one of the most fundamental, concept of RDBMS. A column models a particular attribute inside of the declaration of a particular set of entities. They do not magically...

There is another calendar format is used in the Scandinavian countries and has an ISO standard. It looks like "yyyyW[0-9][0-9]-[1-7]" the W is a number between 01 and 52 or...

I remember the safety rules about always hiring C programmers and UNIX systems guys in pairs. Force them to work as a team. That way if one died or quit,...

>> would hate having to be the DBA going to a place that Celko had designed / created. What a nightmare of missing leading zeros or added leading zeros that...

>> Completed script.<<

Why not start with learning how to write DDL? I've always felt that 80 to 90% of the work in SQL is in declaring your data properly and...

We used to have people who did what was called job secure programming. The code they produced was virtually impossible to read. My favorite, when I worked in the state...

>> For some reason, you insist that COBOL controls everything. <<

Not controls, but influences it. Strongly. Are you still using the Latin alphabet?

>> I don't remember Dr. Codd ever mentioning...

Just some remarks about the way you write SQL. The use of the affix "tbl" is a design flaw called a tibble. It violates the rule about mixing data and...

Every chart of accounts I have ever seen uses a hierarchical encoding scheme. I'm going to assume you've been to all library and seen the Dewey Decimal Classification codes for...

>> Actually most people had separate keypunch operators, it was very rare for a developer to punch his own cards: he/she would be too slow at it and thus use...

Everything we do today is affected by punchcards, and then by COBOL. Look at how 00 programming still assumes a procedural model.

Are you surprised that all animals have DNA? Axle...

This does not sound right to me. Usually, renewal/expiry systems like this require a complete date, not down to the microsecond. But that's not what you described. This is just...