Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
s.[SubscriberKey] [Subscriber Key]
, s.EmailAddress [Email Address]
, case
when r.RegionID = '1' then 'Omaha'
when r.RegionID = '2' then 'Kansas City'
when r.RegionID = '4' then 'Texas'
else 'Online'
end as [Store Location]
, isnull(r.RegionId,'0') RegionID
from Master_Subscribers s with (nolock)
left join RegionID_ZipCodes r on (r.ZipCode = s.[Zip Code])
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment