I'll go one step further. This is not a problem for SQL and we never intended the language to be use this way. Can you preprocess your raw data? You...

30 years ago, when I was on the ANSI X3 H2 SQL standards committee, I used to go out of my way not to offend snowflakes. The result was they...

>> I have a table structure such that each record [sic: row are not records] has a lookback to a previous record [sic]. <<

Since the table is an unordered set,...

The horrible truth is that our calendar system is very irregular in our definition of the business day is even worse. Trying to do some temporal calculations like this with...

>> I have a table called Events, the value of that table like as bellow :<<

Actually you don't have a table in your posting. By definition, a table must have...

>> I am looking to create a CASE statement NOT NULLsic .. <<

There is no CASE statement in SQL; it is an expression

>> that gets different quantities. For example, I...

The Julian or ordinal business day is a good trick. Number the days from whenever your calendar starts and repeat a number for a weekend or company holiday.

CREATE TABLE Calendar

(cal_date...

>> wish to group rows into "sets" based on t_id and t_type. <<

This makes little sense to me. You already have your sets defined by the t_id, So there’s no...

>> Basically I have 2 tables check-in and check-out where users check-in and check-out using an RFID card. I am wanting to display who's in the building or has been...

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