> 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 > AND s.available = 1 > ORDER BY > (s.server_disk_space * s.server_load * s.server_ram) > LIMIT 1; > > Don't forget the semicolon after LIMIT 1 > > Give it a try !!!
I'll give it a shot. To work around the problem I used a cursor. I don't know which is more efficient. I suspect just an inline SELECT statement. I thought I had tried doing a SELECT fields INTO fields without success but I don't remember what that final product looked like. Thanks, Gary