Home Forums SQL Server 7,2000 T-SQL bitwise identity for static lookup table??? RE: bitwise identity for static lookup table???

  • October 7, 2004 at 8:10 am

    #525759

    This design limits the number of possible values to:

    • 31 if the Int field is used.
    • 63 if the BigInt field is used.

    If you are happy with that then why not prepopulate the table.  Issues are only 2n-1

    LinkedIn Profile