Jermuk
03/12/2024, 8:27 AMCREATE TABLE sqlth_1_data (
[tagid] [int] NOT NULL,
[intvalue] [bigint] NULL,
[floatvalue] [float] NULL,
[stringvalue] [nvarchar](255) NULL,
[datevalue] [datetime] NULL,
[dataintegrity] [int] NULL,
[t_stamp] [bigint] NOT NULL DEFAULT 0, -- string conversion from '19700101' is non-deterministic
[partition] AS MONTH(DATEADD(DAY,t_stamp/(1000*3600*24),DATEFROMPARTS(1970,01,01))) PERSISTED,
PRIMARY KEY CLUSTERED ([tagid] ASC, [partition], [t_stamp] ASC)
) ON PS_TAGHISTORY_BY_MONTH ([partition]);
Could be made compatible with UMH through a view