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-2... 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...

If their plan fails, they can always go back to tipping Dogecoin or peddling courses on how to get rich quick by buying cheap stuff on AliBaba and reselling it...

There is...

Maybe so.  Can your chatbot make the case for it? ...

I wrote my own little dity.  Basically, it skips anything that has been rebuilt in the last 22...