/*results.asp case=Region*/ SELECT MarkerID, Marker, Memorial INTO #R1369608Region1042324316 FROM Markers WHERE Accepted Is Not Null AND Withdrawn Is Null And Rejected Is Null AND ReplacedByID is Null AND ( EXISTS (SELECT 1 FROM RegionList rl WHERE rl.RegionID=3694AND rl.AllCountry = 1 AND Markers.Country = rl.Country) OR EXISTS (SELECT 1 FROM RegionList rl WHERE rl.RegionID=3694 AND rl.AllState = 1 AND Markers.Country = rl.Country AND Markers.State = rl.State) OR EXISTS (SELECT 1 FROM RegionList rl WHERE rl.RegionID=3694 AND rl.AllCountry = 0 AND rl.AllState = 0 AND rl.Zip = '' AND Markers.Country = rl.Country AND Markers.State = rl.State AND Markers.County = rl.County) OR EXISTS (SELECT 1 FROM RegionList rl WHERE rl.RegionID=3694 AND rl.AllCountry = 0 AND rl.AllState = 0 AND rl.Zip != '' AND Markers.Country = rl.Country AND Markers.Zip = rl.Zip) )