I can't find anywhere that anyone has done this, though I'm certain that you all have.

I have a 2 character TableID.
I have a datetime value.

I would like to combine those together and somehow covert that into a unique Primary Key value 16 characters. Should I just concatenate the two?

[AA]+ttoc(datetime(), 1)

Will that assure uniqueness across various systems that will not be sharing a table from which they can pull the next available number?


Thanks for your comments.

DJ