is there a way for a stored procedure to move on to the next statement or maybe loop iteration only after person running it hits a return button or maybe types GO and then return? I think i've seen something like this before but that solution might only have allowed one interaction. the proc will update some data between a before select and after select ad if the operator doesnt like something he/she sees, there would be an option to stop.