Posted by angsql on 11/24/05 13:08

I made the change, still I am not getting the result

set nocount on
delete from loop_projectid

while 1=1
Begin
insert into loop_projectid
select top 500 project_id, project_name from pds_project P
where not exists ( select * from loop_projectid L where
P.Project_id=L.Project_id )

declare @rowcount int
select @rowcount=@@rowcount
select @rowcount as rows11

--set @rowcount=@@rowcount

if @rowcount < 500
begin
break
End
end

select * from loop_projectid


..AS

[Back to original message]