find all where column value exist in an array (no loop?)

Did the array (@city_array) values come from the database? If so, you can probably do better letting the database do the JOIN. Post a bit more code and you might get more help. (The relevant schema and models might help, too.)

-Rob

Rob Biedenharn http://agileconsultingllc.com Rob@AgileConsultingLLC.com