In a nutshell...
I select a bunch of rows using " With X as..."
part of the query that follows displays the selected rows using "Select * from X... "
other code will modify the same rows using "Update X ... ".
... and I comment out the section I don't want to run. Purely amateur work I know.
Is there a way to use the same "WITH X as... " query and have it pause and present an option to me where it asks if I want to view or modify the resulting rows? It would then jump to the relevant "subroutine". I could figure this out in VBA but not here.
It would be ideal to create a little desktop app for this purpose but that's for another day. For now this is all in SSMS.