CREATING AN ABSTRACTION LAYER IN SQL SERVER - A Developer's Guide to Data Modeling for SQL Server - page 252

WHEN MATCHED THEN
UPDATE
SET email=@email,
firstname=@firstname,
lastname=@lastname,
homephone=@homephone,
workphone=@workphone,
mobilephone=@mobilephone;
SELECT @customer_objid = objid
FROM tbl_customer
WHERE customer_id = @customer_id;
MERGE tbl_address AS current_addresses
USING
(
SELECT customer_objid = @customer_objid,
address_label,
addressline1,
addressline2,
city,
region,
country,
zipcode,
is_deleted
FROM @addresses
)
AS source_addresses(customer_objid,
address_label,
addressline1,
addressline2,
city,
region,
country,
zipcode,
is_deleted)
ON
(
current_addresses.address_label =
source_addresses.address_label
AND
current_addresses.customer_objid =