Forum Replies Created

Viewing 15 posts - 121 through 135 (of 1,413 total)

  • Reply To: query run time changes alot...why?

    This reminds a little of a similar topic from a few weeks ago

    https://www.sqlservercentral.com/forums/topic/inconsistent-query-execution-times

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    March 11, 2024 at 3:59 pm

    #4393458

  • Reply To: row changes per hour by TagID

    One way could be to add the date and hour to the GROUP BY

    select t.tagid, cast(v.ss_dt as date) day_dt, datepart(hour, v.ss_dt) hr,
         ...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    March 6, 2024 at 7:29 pm

    #4390827

  • Reply To: how to filter out zeros when calculating average

    For the denominator you could sum SIGN(ABS()) functions.  The SIGN function returns -1, 0, or 1 depending on if the input is negative, zero, or positive.  The ABS function returns...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    March 5, 2024 at 10:02 pm

    #4390230

  • Reply To: row changes per hour by TagID

    Bruin wrote:

    Looks like if I add this in my query logic I'm getting the datetime desired

    DATEADD(s,t_stamp/1000,'1969-12-31 20:00:00')

    2024-02-01 01:00:00.000 2024-02-01 01:00:01.000

    Struggle with doing the count of records per TagID within the...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    March 5, 2024 at 8:05 pm

    #4390185

  • Reply To: row changes per hour by TagID

    Bruin wrote:

    CREATE TABLE [dbo].[tmp_sqlt_data_1_2022_05](
    [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,
    PRIMARY KEY CLUSTERED 
    (
    [tagid] ASC,
    [t_stamp] ASC
    )WITH (PAD_INDEX =...

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

    March 4, 2024 at 7:06 pm

    #4389543

    • Viewing 15 posts - 121 through 135 (of 1,413 total)