Is it possible to take a user input during the time when the stored procedure runs? Like pause for a moment and ask for a user input and then continue?
There is a parameter @query inside my stored procedure and I want the option in which the user can modify the value of this parameter at a certain point of the procedure.

Check Solution