>> Suppose I have TABLE Customers and TABLE Orders. The relationship is that 1 customer can have many or no orders. <<

The conventional SQL forms for over 30 years has...

>> I'm trying to get a list of ID's that have a total sum of their amount column = to zero... But I'm getting a lot of negative numbers, but...

CREATE TABLE Samples

(sample_id CHAR(3) NOT NULL PRIMARY KEY.

DEFAULT 0,

col_1 INTEGER NOT NULL

DEFAULT 0,

col_2 INTEGER NOT NULL

DEFAULT (0));

INSERT INTO Samples (sample_id, col_1, col_2)

col_value ('AAA', 0, 0), ('BBB', 0, 0), ('CCC', 0,...

This thread is giving me flashbacks to the days when I wrote columns on structured programming in the trade press. That was decades ago! In particular, there was the Bohm-Jacopini...

If you want us to help you with your code, you probably ought to show it to us. Just offhand, my guess would be that something is wrong with your...

A go to statement can jump into the middle of a begin – end block. This means that all of those local variables have to be allocated beginning of the...

>> I've been working a little bit with a few tables here, they've got "CreatedDate" as clustered Index and and Id (UniqueIdentifier) as Primary Key. The Id's are generated from...

>> I did NOT have any involvement with the creation of the DB's design. .. do NOT have any access to modify the design <<

There is an old poem:

" I...

After all these decades. I don't remember why the inmate number was that long. I believe we display the first nine digits because that matches the Social Security number. The...

For over 35 years, SQL forums have asked posters to provide DDL, sample data and their first honest attempt at a solution on their own.

I had a little something extra...

Jeff, have you noticed that most credit cards are 16 digits broken into groups of four? American Express or Diners Club or older credit card systems uses a little bit...

>> I have a query that produce a table where I have a list of columns. Then I choose check what columns are on the table excluding the column from...

This is correct You got so much wrong in your design. I'm trying to figure out where to start. Your column declarations make no sense; a variable length. 30 characters...

>> I need a way to find all of the related records sic in a set of relationships given any record_id sic in the set. The nature of the relationships...

In the future, would you mind following forum rules of been in place for over 30 years and post DDL? It would also help if you would read just one...