hi guys my sql code sodelete from numbersdeclare @i as int set @i = 3440000 while(@i < 3442047) begin insert into numbers values(@i) set @i = @i+1 endselect ph from numbers where ph not in(select phone from phone where phone >=3440000 and phone<=3442047)
query works fine and Results 144 query strings 3442047 changed to @ t1 and created a procedurecreate alter proc trt @i int,@t1 intas delete from numberswhile(@i < @t1) begin insert into numbers values(@i) set @i = @i+1 endselect ph from numbers where ph not in(select phone from phone where phone >=@i and phone<=@t1)
exec dbo.trt @i=3440000,@t1=3442047
but Results this query 2047 linesmeans a procedure does not work this scriptselect ph from numbers where ph not in(select phone from phone where phone >=@i and phone<=@t1)
someone can advise how I can change this procedure? To have a good Resultsthank'shttp://sql-az.tr.gg/