delete from <PREFIXE_DW>ZONES_GEO
<SEPARATEUR>
insert into <PREFIXE_DW>ZONES_GEO (ZGE_CODE_CENTRE,ZGE_CODE_DECOUPAGE,ZGE_CODE_ZONE_GEO,ZGE_TYPE_LIEN
)  
select distinct CODE_CTR,DCOUP,ZONEGEO,'CENTRE'
from <PREFIXE_HA>DGEOCTRE <WITHNOLOCK>
<SEPARATEUR>
insert into <PREFIXE_DW>ZONES_GEO (ZGE_CODE_DECOUPAGE,ZGE_CODE_ZONE_GEO,ZGE_TYPE_LIEN
)  
select distinct CODEDCP,ZONEGEOG,''
from <PREFIXE_HA>ZONESGEO <WITHNOLOCK>
<SEPARATEUR>
insert into <PREFIXE_DW>ZONES_GEO (ZGE_CODE_FOURNISSEUR,ZGE_CODE_DECOUPAGE,ZGE_CODE_ZONE_GEO,ZGE_TYPE_LIEN
)  
select distinct CODE_FOU,DCOUP,ZONEGEO,'FOURNISSEUR'
from <PREFIXE_HA>DGEOFOUR <WITHNOLOCK>