CREATE   PROCEDURE UpdateAllAccounts
AS

declare @ip varchar( 23 ), @port smallint, @login varchar( 25 ), @ret int, @fetch_status int

CREATE TABLE #temp (Login varchar( 25 ), IP varchar( 23 ), Port smallint)

DECLARE tables_cursor CURSOR STATIC FOR select Login, IP, Port from ActiveClients
OPEN tables_cursor

FETCH NEXT FROM tables_cursor INTO @login, @ip, @port

WHILE (@@FETCH_STATUS <> - 1 )
begin
	Exec @ret=AccountUpdate @login, @ip, @port,  0 
	if @ret= 1 
	begin
		insert into #temp values (@login, @ip, @port)
	end
	FETCH NEXT FROM tables_cursor INTO @login, @ip, @port
end

CLOSE tables_cursor
DEALLOCATE tables_cursor

select * from #temp