May 02, 2011 06:30 AM|Mikesdotnetting|LINK
I would store assigned numbers in a separate column along with another column that keeps the type (mc, mm etc):
then you can get the next number for managers with this type of query:
SELECT MAX(AssignedNumbers)+ 1 As NewID FROM YourTable WHERE EmployeeType = 'mm'
You need to check how many digits are in the number before constructing your Identity as a string.