CREATE TABLE Passaggi

(foobar_code VARCHAR(6) NOT NULL,

passagggio_timestamp DATETIME2(7) DEFAULT CURRENT TIMESTAMP NOT NULL,

PRIMARY KEY(foobar_code, passagggio_timestamp),

servizio_id SMALLINT NOT NULL);

>> I want to insert the record [sic: rows are not records] or do...

SQL Programing Style

ISBN 0-12-088797-5

Amazon has all of my stuff

I wrote an entire book on this topic, based on the work I did at AIRMICS. Look at ISO-11179 and the Metadata Committee stuff. We found  that with good formatting,...

I wrote an entire book on this topic, based on the work I did at AIRMICS. Look at ISO-11179 and the Metadata Committee stuff. We found  that with good formatting,...

SQL FOR SMARTIES 5th edition, chapter 18.2 goes into a lot of painful details znd works it all out

Yes, that is how NOT  IN () is defined in ANSI/ISO Standard SQL.

instead of thinking like procedural language programmer, build a table for 200 ro 500 years. Why compute constants over and over?

CASE is an expression,not a statement. This basic programming not just SQL.  you should use COALESCE(<list>) to pick the first non-null value.  But more than that , you gave us...

Use CREATE SEQUENCE See https://www.red-gate.com/simple-talk/databases/sql-server/learn/sql-server-sequence-basics/

SQL is a declarative language, but you write it as if it were procedural. CASE is an expression, not a statement. IF-THEN controls flow of execution. Since you did not...

In a set-oriented language you return the whole set of values that are temporally equal toMight wan the min(date diff) over(patition by account) .

Look up Dr. Codd's T-Join for something...

I am on an old Chrome book wthout any SQL on it for testing, but could we use MIN( DATEDIFF(DAY, ..) OVER OVER(PARTITION BY tb.CustNo  ..) ? People forget the...

This was called a singleton SELECT  in Standard SQL and it loaded one row into local storage. Microsoft generalized it.

Not really. A basic principle of a modern tiered architecture  is xto do diplay owrk in a presentation layer, in the database.

Simak was wrong; time is not the simplest thing. There are points in time ("high noon at the OK Coral") and maybe space,then there are durarions ("that is a 15...