1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62
| update dim_address
set
document_id = Ea.document_id,
document_model = Ea.document_model,
document_label = Ea.document_label,
firstname = Ea.firstname,
lastname = Ea.lastname,
email = Ea.email,
company = Ea.company,
addressline1 = Ea.addressline1,
addressline2 = Ea.addressline2,
addressline3 = Ea.addressline3 ,
zipcode = Ea.zipcode,
city = Ea.city ,
province = Ea.province ,
countryid = Ea.countryid ,
phone = Ea.phone ,
mobilephone = Ea.mobilephone ,
document_modificationdate = getDate()
from
( select
document_id ,
document_model ,
document_label ,
firstname ,
lastname ,
email ,
company ,
addressline1 ,
addressline2 ,
addressline3 ,
zipcode ,
city ,
province ,
countryid ,
phone ,
mobilephone ,
document_creationdate ,
document_modificationdate
from m_customer_doc_address
WHERE NOT EXISTS (
select
document_id ,
document_model ,
document_label,
firstname ,
lastname,
email,
company ,
addressline1,
addressline2 ,
addressline3,
zipcode ,
city ,
province ,
countryid ,
phone ,
mobilephone,
document_creationdate,
document_modificationdate
from dim_address)) as Ea, dim_address as a
where a.document_id = Ea.document_id. |
Partager