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

This code works

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 )

if @@rowcount <= 500
begin
break
end
End
select * from loop_projectid

..AS

• Next in forum: Re: Timeout Period in SQL Server 2005
• Prev in forum: Re: 100 % CPU Usage
• Thread view: Re: How copy table data from one database to another

[Reply to this message]