Hi Kevin

I had mentioned this previously that I had mistakenly put this question in this blog as I needed the solution for SQL 2008 R2 which unfortunately doesn't support sequence....

sure john i will let you know all in detail. i would look forward for your suggestion in this.

this is a new table which will get offer feed from a...

HI Alan,

Can you please let me know if you got time to sort this out ? I might need a solution which is applicable for sql server 2008 r2.

best regards,

in case of sql server 2008 can there be a solution for this ? i'm new to sql server central so might not have given the sql version i'v to...

understands the suggestions very much. Can someone of you please en-light me a proper solution for this then ? only bit problematic is - the table will have new rows...

Hi Alan,

Thank you very much for replying back so early.

Its sort of a business requirement that's why i want to reuse them also this value can hold till 99999 which...