One of the tables I write some values to has 2 columns. A 'binary' type column, and a 'uniqueidentifier' type colum.

When I insert a 1 into the binary column, a uniqueidentifier is created based on the number of seconds since midnight...or something to that effect.

But once I have created this item, I need a way to go back and extract this unique identifier so that I can put this value in some other tables. Trouble is, I have no means of looking this new uniqueidentifier that was just created.

Does anyone see a way how I can get it? It's been a long day and I'm tired...maybe I'm just not thinking straight.

If someone can see a way around my problem, I'd be very appreciative.

Thanks

dvst8