|
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
Navigation:
[Reply to this message]
|