, .
, :
select subject
, RegardingObjectIdName
, statecodename
, owneridname
, Activitytypecodename
, CreatedOn
from filteredactivitypointer ap
where not exists(select *
from filteredactivityparty ay
where ap.activityid=ay.activityid
and ay.participationtypemaskname = 'Owner')
, , .
, .
, , - , Activity Owner.
select subject
, RegardingObjectIdName
, statecodename
, owneridname
, Activitytypecodename
, CreatedOn
from filteredactivitypointer ap
where (select COUNT(1)
from filteredactivityparty ay
where ap.activityid=ay.activityid
and ay.participationtypemaskname = 'Owner') > 1
( , ).
: http://social.microsoft.com/Forums/en-US/6f67ffaa-7162-4030-b2ee-af23af6b4cf5/error-when-assigning-certain-record-in-crm-error-there-should-be-only-one-owner-party-for-an?forum=crm, CRM 4.0, 2011 .