I'm glad it worked out for you. Jim Belisle wrote:
A big thanks to John and Albert for helping me learn the DECLARE CURSOR and WHILE LOOP commands so I could auto number rows based on a specific criteria. I got the temp table to insert the proper number of rows & auto number them properly.Thanks again for your patience and explanation of how the logic worked with these commands.Jim
