for reference i didnt want to use the cursor as its inefficient.

row_number works a treat many thanks for the feedback