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.

Post deleted... we may have found an even better way yet.  I'll be back.

I tested Steve Munson's good code.  After changing the input variable from 22 to 30 characters max (15 bytes hex), it works fine but it's a bit greedy on CPU. ...

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 7:37 pm
            
#4161165

            
            
                                                
        

Nicely done, Mr. Munson.

You've...

Heh... old post I know but, for others reading this, stop putting login names and passwords in clear text in batch files.  Use only proper "trusted connections".

That's...

Imo it depends on whether or not Approved is exactly equivalent to Taken.  Could a user be officially approved and yet not take the day?  If there's an exact...

With the proviso that I don't know the exact situation...

The purpose of such a table is to audit what's happening to the data, no matter what.  Are you absolutely sure...

All,

I would like to give a user permission to set system_versioning on or off on a table. I know that one way to do this is to give them...

Thanks, for the feedback, Warren.  I was worried for ya! 😀

Yowch.  That doesn't seem right.  Thank you for the feedback.

I don't use SSRS so I ask the following question in earnest... why do you need to use XML for this to begin with?

As a bit of a sidebar, have you checked for code that either takes a backup somewhere outside of CommVault and have you checked to make sure no one wrote...