is it possible to do a loop inside a stored procedure?
assuming my sp receives 2 integers (@iC1 and @iC2)
(there are other parameters as well, but they don't matter for the example)
Now, lets say @iC1 = 5 and @iC2 = 17
Then i would like a loop that creates the amount of records
For @iCT = @iC1 To @iC2
Insert into ....
Can this be done somehow?