thanks all for help on the logic !

So have made changes to the original script but the last while loops end ups in an infinite loop still but the rest is a lot better

--Create...

thank you all for advice

code formatted for code apologies.

I will look down the where clause to check if NULL

and redirect the where clause to different rows for each execution