To give a user the ability to execute a stored procedure (EXECUTE AS)  I must first grant him the ability to impersonate the 'sa'.

(that procedure creates new login and...

Sorry about the previous post... I had an extra  "60" in it instead of a 100.

Anyway, using the integer math suggestion and the test table setup that Phil posted along...

• This reply was modified 5 years, 6 months ago by Jeff Moden. Reason: Made fix to change "ss" to "mi" in the code

Sorry... Dropped the post... I'll be back...

Do you have a DBA review process that occurs sometime before testing?  I can't speak for anyone else and probably have a different experience but, unless you have a DBA...

All you need is to convert normal numerical sequence to desired codes.

Something like this:

declare @a tinyint, @b tinyint, @t smallint 
select @a = 6, @b =...

I don't even know how to spell "read_committed_snapshot" but we recently had a 3rd party vendor create a database that uses it and your problem does have a concern for...

What is the max?  Z6?  I ask because that will mean that you have a total capacity of 26*6 or 156 unique values before you run out.

If you'd provide your example data in a "Readily Consumable Format" (please see the article at the first link in my signature line below for one way to do that),...

FINALLY IT WORKS 🙂

the issue was in how to call the function not in the mentioned above modified function

it works fine when i used this to call it

            
September 29, 2020 at 1:46 pm
            
#3791631

            
            
                                                
        

In your comment about the fill factor, "All the pages you see at the 70% line are stuck at 70% FOREVER." I

If I change this fill factor to 100%...

The key here is to always remember what's important in these types of things... it's massively important, even if all the code is done in T-SQL, to keep the data-layer...

BWAAAA-HAAAAA!!! Nice tutorial but I find it odd to see a Postgre tutorial on a site names after SQLServer. 😉

So, it uses the same kind of lookup table but stored in Windows Registry.

Not sure how gods is it in terms of performance, but it does not eliminate the...

... post deleted.  Accidental duplicate.

.. post deleted.  Didn't see the OP's latest post.