Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT a.*, b.*
- FROM CuMe_Curr_Cont AS a
- INNER JOIN [HMCServer].HMCCurrentMembers.dbo.Cume_curr_cont AS b
- ON (a.Cont_Mem_Numb = b.Cont_Mem_Numb AND a.Cont_Cont_Numb = b.Cont_Cont_Numb)
- WHERE
- BINARY_CHECKSUM (a.cont_mem_numb, a.Cont_Cont_Numb, a.Cont_Club_Code, a.Cont_Pur_Date, a.Cont_Occp_Date, a.Cont_First_Mfee,
- a.Cont_Cls_Date, a.Cont_Canx_Date, a.Cont_Developer, a.Cont_Link, a.Cont_Mana_Fee, a.Cont_Cont_Status, a.Cont_LRC_No, a.Cont_No_Of_Weeks, a.Cont_Exdate
- , a.Cont_Currency, a.Cont_Admin_Fee, a.Cont_Tradein_Fee, a.Cont_Cont_Total, a.Cont_Venue, a.Cont_Trans_Date, a.Cont_Processed, a.Cont_Serv_Admin_Fee
- , a.Cont_Serv_Tradein_Fee, a.Cont_Serv_Total, a.Cont_Serv_Currency, a.Cont_Finance_Co, a.Cont_Tax, a.Cont_Trade_In, a.Cont_Pur_Admisson_Fee, a.Cont_Serv_Appl_Fee
- , a.Cont_Serv_Total_Fee, a.Cont_Salesrep, a.Cont_TOManager, a.Cont_Affil_Club, a.Cont_RH_Date, a.Cont_Collector, a.Cont_ButtonUp, a.Cont_CFS, a.Cont_DSR_Date
- , a.Cont_Finance_Amt, a.Cont_Mrkt_Company, a.Cont_Col_Canx_Date, a.Cont_Batch_Id, a.Cont_Upd_Date) <>
- BINARY_CHECKSUM(b.cont_mem_numb, b.Cont_Cont_Numb, b.Cont_Club_Code, b.Cont_Pur_Date, b.Cont_Occp_Date, b.Cont_First_Mfee,
- b.Cont_Cls_Date, b.Cont_Canx_Date, b.Cont_Developer, b.Cont_Link, b.Cont_Mana_Fee, b.Cont_Cont_Status, b.Cont_LRC_No, b.Cont_No_Of_Weeks, b.Cont_Exdate
- , b.Cont_Currency, b.Cont_Admin_Fee, b.Cont_Tradein_Fee, b.Cont_Cont_Total, b.Cont_Venue, b.Cont_Trans_Date, b.Cont_Processed, b.Cont_Serv_Admin_Fee
- , b.Cont_Serv_Tradein_Fee, b.Cont_Serv_Total, b.Cont_Serv_Currency, b.Cont_Finance_Co, b.Cont_Tax, b.Cont_Trade_In, b.Cont_Pur_Admisson_Fee, b.Cont_Serv_Appl_Fee
- , b.Cont_Serv_Total_Fee, b.Cont_Salesrep, b.Cont_TOManager, b.Cont_Affil_Club, b.Cont_RH_Date, b.Cont_Collector, b.Cont_ButtonUp, b.Cont_CFS, b.Cont_DSR_Date
- , b.Cont_Finance_Amt, b.Cont_Mrkt_Company, b.Cont_Col_Canx_Date, b.Cont_Batch_Id, b.Cont_Upd_Date)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement