Keep it simple

DECLARE @sample TABLE
        (
             ...

Without having to look much at the code you posted, what is the unit value of the h.run_time column?

They do it in a lot of languages... I hate it when people number the bits differently than the exponent of "2".  😀

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

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

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