CREATE proc [dbo].[provision_time]
as
declare
@a int
set @a=1
while(@a<19)
begin
insert into ProviMo (id,phone,actionid,LinkID,serviceid,content) select top 10 id,FeeUser_ID_MSISDN,ActionID,LinkID,SPServiceID,FeatureStr from dbo.ProvisionMO where id not in(select id from ProviMo) order by id
--set @a = @a + 1
waitfor delay '00:00:10'
end
GO