I was looking for ways to create the functionality to autogenerate customized serial IDs so I came up with this. It can be customized even further depending on you ID generation requirements.
To use this:
1. Create the table and stored procedure
2. Execute the stored procedure to autogenerate your serial ID.
The autogenerated ID can be saved again depending on what you a developing etc. etc.