I've written a simple stored procedure in MSSQL. It takes an identifier and returns the next available number for that identifier from a table storing the last number used. If the identifier doesn't ...