declare @i int set @i=0 while @i<10 begin insert into dbo.w10test(Name) select Name from dbo.w10test set @i=@i+1 end;