query in the picture.
Then you can recall or rerun the STORED PROCEDURE with
different parameters each time.
You may need to two parameters, one as SELECT variable and
one in the WHERE condition, as blue circled in the follow
picture.
Just an idea, No SQL Sever to try.