временную процедуры

create proc #f
@for INT
AS
BEGIN

DECLARE @cnt INT = 0;

WHILE @cnt < @for
BEGIN
   SELECT 1
   SET @cnt = @cnt + 1;
END;

END;