• My use of Except, Intersect is to prepare a slowly changing dimension table as written below. This will help me to get the changed address as well as new records. How can i re-write this in sql without EXCEPT operand

    SELECT CustomerID, Address1, District, Phone1, Phone2,....some 50 col FROM CustAddress_OLTP

    EXCEPT

    SELECT CustomerID, Address1, District, Phone1, Phone2,....some 50 col FROM CustAddress_SCD