As everyone have suggested ROW_NUMBER() would help you in your requirement.
But my suggestion is that you create a Dimension(Master) table which have all the AD domain names. You can have a primary key in this table and then you can reference this key in your actual table. This way search on primary key of this table would be faster as it'll be only integer.
Chaos isn’t a pit. Chaos is a ladder. Many who try to climb it fail and never get to try again. The fall breaks them. And some are given a chance to climb, but they refuse. They cling to the realm, or the gods, or love. Illusions. Only the ladder is real. The climb is all there is.
No comments:
Post a Comment