SELECT * FROM #Request.prefix_db_lookup#.Agency
WHERE Agency_ID = #url.agencyid#
SELECT StateName, StateAbbr FROM #Request.prefix_db_lookup#.States ORDER BY StateName
SELECT Topic_ID, Topic FROM #Request.prefix_db_lookup#.IncidentTopic Where Subject = 'CAHPS' Order by Topic