In the future, would you mind following forum netiquette? That means you're supposed to post DDL, and not pretty colored pictures. What little we can figure out from your DML...

In the future, would you mind following netiquette and post DDL for us? You have several fundamental mistakes in your design. Status is not a kind of entity; it's an...

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