select interactiondate, reminderdays, interactionMethod, interactionAttributeId from tbl_crm_interactions where interactionid = and ownerid = and ownertype = select ia.interactionAttributeId, ia.name, ia.IsDefault from tbl_CRM_InteractionAttributes ia with (nolock) where ia.ownerId = and ia.ownerType = order by ia.sortRank
Call Date
Reminder
checked> checked> checked> checked>
Interaction Method
checked> checked> checked> checked>
Call Attribute
checked>