[raven001]

I currently have a requirement to where on a SQL 2000 box using .asp or ASP.net I need to generate a unique number and record the time it was generated in a table and then continue to use that unique number to insert and update data in another table.

I have no problem with the inserting and updating of data in a table, but I am at a loss as to how to kick the whole thing off by generating the unique number, recording the time and then using the unique number for inserting data into another table.

Could someone please help me with this or point me in the right direction to learn more or a tutorial?

Thanks in advance!