I have a stored procedure that I want to execute 1-10 times with a set of variables
I want to feed in a comma seperated list...and execute the stored procedure for each varchar(10) item in the list.
Declare @myVar varchar(100)
Set @myVar = 'set1,set2,set3'
My SP would then execute 3 time
exec mySP 'set1'
exec mySP 'set2'