If you are seeking a unique number like in Oracle when you use a sequence (which I so wish SQL server had) you can do what I have done....

Create a...