RE: Stored process accessing tables in different database

2007-03-02 Thread Gary W. Smith
> You SELECT statrment > SELECT > (s.server_disk_space * s.server_load * s.server_ram), > s.server_fqdn, > s.server_url, > s.server_id > INTO > L_server_load, > L_server_fqdn, > L_server_url, > L_server_id > FROM clientdev.servers s > WHERE s.active = 1 >

Re: Stored process accessing tables in different database

2007-03-02 Thread Rolando Edwards
You SELECT statrment SELECT (s.server_disk_space * s.server_load * s.server_ram) INTO l_server_load, s.server_fqdn INTO L_server_fqdn, s.server_url INTO L_server_url, s.server_id INTO L_server_id FROM clientdev.servers s WHERE s.active = 1 AND s.available = 1 ORDER BY