CREATE PROCEDURE dbo.mod_bill_update_performance 
AS 
    BEGIN 
    declare  @remote_path varchar( 150 ), @IdDatabase T_ID, @IdDatabaseChar varchar( 10 )
    declare remote_path_crs cursor for select IdDatabase, remotepath from mod_bill_remote_SDB for read only 
    open remote_path_crs    

    WHILE ( 1 = 1 )
    BEGIN
    fetch remote_path_crs into @IdDatabase, @remote_path 
    if (@@sqlstatus= 0 )
    begin
        select @IdDatabaseChar=convert(varchar, @IdDatabase)
        --exec sp_addobjectdef "dzk_dev_local..mod_bill_Performance_PROXY", "spionersybase2.dzk_dev..mod_bill_Performance1", "table"
             EXECUTE ('CREATE EXISTING TABLE mod_bill_Performance_PROXY ('+
            'IdDatabase  T_ID    null, ' +
            'IdForeignPerformance    T_ID    not null, ' +
            'IdShow  T_ID    null, ' +
            'ShowName    nvarchar(255)   null, ' +
            'IdHall  T_Id_Fix    not null, ' +
            'PerformanceTime T_DATE_ONLY null) ' + 
        'EXTERNAL TABLE AT ' + "'" + @remote_path + "'")
        EXECUTE ('UPDATE STATISTICS mod_bill_Performance_PROXY')
        EXECUTE ('SELECT * from mod_bill_Performance_PROXY')
        EXECUTE ('INSERT INTO mod_bill_Performance2 SELECT ' + @IdDatabaseChar + ', IdForeignPerformance, IdShow, ShowName, IdHall, PerformanceTime FROM mod_bill_Performance_PROXY') 
        EXECUTE ('DROP TABLE mod_bill_Performance_PROXY')
    end
    else break
    END
    close remote_path_crs      
    deallocate cursor remote_path_crs      
    END