SELECT [Datetime] 
FROM [mydbtemp] 
WHERE [Tagvalue] = 1 
AND [Datetime] > (SELECT MAX([Datetime]) 
FROM [mydbtemp] 
WHERE [Tagvalue] = 0 
AND [Datetime] BETWEEN '2023-02-01 01:00:00' AND '2023-02-05...

The table you are selecting from (my_table) is not the table you have created (mydbtemp). Also the column names are different.

I think you meant to put this as your query:

Serious "chicken dinner" there for performance, Jonathan... here are the stats from a test on a million rows of 16 hex digits (8 bytes)...

 SQL Server...

Serious "chicken dinner" there for performance, Jonathan... here's stats from a test on a million rows of 16 hex digits (8 bytes)...

 SQL Server Execution Times:
...

That's because bigint stores integers as Two's complement, negative numbers need 2^64 (18446744073709551616) added to them to represent the number as an unsigned int.

            
March 15, 2023 at 8:47 pm
            
#4161185

            
            
                                                
        

That's because bigint stores integers as Two's complement, negative numbers need 2^64 (18446744073709551616) added to them to represent the number as an unsigned int.

SELECT...

I would guess your trigger should look something like this:

CREATE TRIGGER software_on_install_fill_in 
ON software
FOR INSERT, UPDATE
AS BEGIN
    SET NOCOUNT ON

    UPDATE...

It would help if you included the table ddl for package and software.

SELECT ID
FROM ExampleTable
GROUP BY ID
HAVING MAX(CASE WHEN Description = 'Apex' THEN 1 ELSE 0 END) = 0 OR
    MAX(CASE WHEN Description = 'BILL'...

It seems to be ordered by original post date descending.

Active Threads is ordered by last post date descending.

SELECT '1' AS 'CommitBlock',
       '1' AS 'EnforceTagExistence',
       (SELECT vw_deferments.loan_number AS '@loannumber',
    ...

I updated the procedure (for my purposes) so it doesn't attempt to update stats on the sys schema by updating one of the ANDs in the WHERE to include 'sys':

@Jonathan... that will work if "any" of the 3 are present.  I'm thinking the OP only wants to exclude if all 3 are present.  But, please, let him explain...

Attached.  Again, I'm very aggressive in the code.  If the RowModCtr > 0, then I rebuild the stats.  You can certain modify that...

Dear ChatGPT

I have a table where it has id column, along with description.

Based on Group BY ID, I need to verify for each ID we have row exists with Description...