CA SDM - MS SQL Query Contact x Notification Method

Document created by TMACUL Champion on Apr 1, 2016
Version 1Show Document
  • View in full screen mode

aaa

 

select cnt.contact_uuid, cnt.userid, cnt.last_name, m1.sym as method1,  m2.sym as method2,  m3.sym as method3,  m4.sym as method4

from ca_contact as cnt

left join usp_contact as usp on cnt.contact_uuid = usp.contact_uuid

left join ct_mth as m1 on usp.c_cm_id1 = m1.id

left join ct_mth as m2 on usp.c_cm_id2 = m2.id

left join ct_mth as m3 on usp.c_cm_id3 = m3.id

left join ct_mth as m4 on usp.c_cm_id4 = m4.id

 

 

know_more.jpg

CA SDM - MS SQL - Script select Group Member (Analyst x Group)

CA SDM - MS SQL - Script to count member group

CA SDM - MS SQL Query para visualizar os Logins realizados na solução

CA SDM Cleaning duplicate contacts - MS SQL

2 people found this helpful

Attachments

    Outcomes