Viewing 15 posts - 1 through 15 (of 823 total)
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...
November 22, 2021 at 5:00 pm
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...
November 6, 2021 at 1:40 am
>> 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,...
November 5, 2021 at 9:02 pm
This was removed by the editor as SPAM
November 4, 2021 at 10:23 pm
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...
October 21, 2021 at 3:15 pm
>> 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...
September 29, 2021 at 1:38 am
>> 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...
September 8, 2021 at 3:33 pm
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
September 1, 2021 at 2:23 pm
>> 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...
August 24, 2021 at 5:50 pm
>> 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...
August 16, 2021 at 2:58 pm
>> 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...
August 6, 2021 at 4:34 pm
>> 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...
August 6, 2021 at 3:49 pm
CREATE TABLE Samples
(sample_id CHAR(3) NOT NULL PRIMARY KEY.
col_1 INTEGER NOT NULL
col_2 INTEGER NOT NULL
INSERT INTO Samples (sample_id, col_1, col_2)
col_value ('AAA', 0, 0), ('BBB', 0, 0), ('CCC', 0,...
August 6, 2021 at 3:36 pm
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...
July 19, 2021 at 7:18 pm
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...
July 19, 2021 at 4:10 pm