TABLE A BRANCH_ID ADDRESS_NUMBER ADDRESS_SHIP_TO PRODUCT_ID_KEY ISO_LANGUAGE 1561001 NULL NULL 10005899 en-US 1561001 NULL NULL 10005899 nl-NL 1561001 35023080 NULL 10005899 en-US 1561001 35023080 35023080 10005899 en-US TABLE B BRANCH_ID ADDRESS_NUMBER ADDRESS_SHIP_TO PRODUCT_ID_KEY ISO_LANGUAGE 1561001...

Hi, Here are some referrence, http://www.thescripts.com/forum/thread81361.html http://www.sqlmag.com/Article/ArticleID/48105/sql_server_48105.html http://www.sqlmag.com/Article/ArticleID/15608/sql_server_15608.html Please search the forums as this question has already been answer many times here