institutionZip.sql

use stage
go

    
select distinct left(g.rdt,2) as regon, g.rdtname--, m.ZIP
from d_janssenGeoMap as g
join (select LEFT([1q2013],2) as region, rdtname, zip
      from d_janssenZipMap) as m on m.region = left(g.rdt,2)
      and g.RDTname = m.RDTName
order by 2

select distinct left(g.rdt,5) as district, g.rdtname
from d_janssenGeoMap as g
join (select LEFT([1q2013],5) as region, rdtname, zip
      from d_janssenZipMap) as m on m.region = left(g.rdt,5)
      and g.RDTname = m.RDTName

select distinct g.rdt as ter, g.rdtname
from d_janssenGeoMap as g
join (select [1q2013] as region, rdtname, zip
      from d_janssenZipMap) as m on m.region = g.rdt
      and g.RDTname = m.RDTName

select distinct left(g.rdt,2) as regon, g.rdtname, m.ZIP
from d_janssenGeoMap as g
join (select LEFT([1q2013],2) as region, rdtname, zip
      from d_janssenZipMap) as m on m.region = left(g.rdt,2)
where g.RDT like '%00000' 
order by 2

select distinct left(g.rdt,5) as regon, g.rdtname, m.ZIP
from d_janssenGeoMap as g
join (select LEFT([1q2013],5) as region, rdtname, zip
      from d_janssenZipMap) as m on m.region = left(g.rdt,5)
where g.RDT like '%00' and g.RDT not like '%00000'
order by 2

select distinct g.rdt as regon, g.rdtname, m.ZIP
from d_janssenGeoMap as g
join (select [1q2013] as region, rdtname, zip
      from d_janssenZipMap) as m on m.region = g.rdt
where g.RDT not like '%00' and g.RDT not like '%00000'
order by 2