. Did you know there's an ISO 8601 standard for the week within a year display format of the date? It looks like "yyyyW[0-5][0-9]-[0-7]", where "yyyy" is the calendar year,...

>> I have this function, but I wanted to pass a table so as to use the same function to get the job done for multiple tables. For example, I...

>> Jcelko... not sure what your issue is, we all get tired of seeing repeat mistakes but there are times for discretion and actual help as well. <<

I'm a grumpy...

In the future, would you mind following the basic netiquette that's been in effect for over 30 years on SQL forums and post real DDL?

CREATE TABLE Inventory

(gtin CHAR(15) NOT NULL...

For over 30 years, SQL forms have required that you post DDL. Why do you feel you are exempt? Let me go ahead and do what you should have done...

Why did you fail to post DDL? Have you ever read any of the posting rules on any SQL forum for the past 30+ years? Why do you think anyone's...

I've been teaching SQL and RDBMS for a few decades now. I spent 10 years of my life. The standards committee for the language and have 10 books on it...

First, would you explain why you didn't post any DDL. This is been basic netiquette for over 30 years on SQL forms. Why are you exempt?

Second, your narrative is wrong....

Your approach to SQL is completely wrong. Client/server architectures are based on tiers. One of these tears is a displayed level, which is where we put in commas and punctuation...

You don't seem to know the table must have a key. By definition, not as an option. Furthermore, we cannot be all NULLs. Basically, you posted a very badly designed...

If you actually need a sequence, then we have a CREATE SEQUENCE statement in the language I need to just generate a set of integers then I would use

SELECT (units.i...

The dash-dash marks a comment that ends at the newline. This convention comes from IBM and punchcards in the early days of DB2.

>> I am trying to add a column to a table that ranks the number of occurrences of repeated data. All I can currently find is how to count the...

>> I remember learning Algol during a teacher strike while I was in High School back when dinosaurs still roamed the land. I actually liked the language. <<

I learned Fortran...

A little bit of history here. The ANSI/ISO Standards committee decided that the grammar for SQL would be LALR(1). One of the committee members had access to a really good...