I have a table with two columns (RecordName, Id). I'm trying to create an 8 Character ID unqiue for each record using the characters A-Z (except for the letters L,O,I). The characters will need to be random and unique (the Ids should be executed using a stored procedure).
I'm not sure if I can create an array and loop through it for each record...
Does anyone have any suggestions?
I started by creating a temp table with the letters in there, but then I wasn't sure how to do the rest or if it should be done differently. I would appreciate the input.