USP_DATALIST_MARKETINGPLANITEMTASKUNMAPPEDOWNERS
Returns a list of marketing plan item owners who are not mapped to staff members.
Definition
Copy
CREATE procedure dbo.USP_DATALIST_MARKETINGPLANITEMTASKUNMAPPEDOWNERS
as
set nocount on;
select distinct
MKTMARKETINGPLANITEMTASK.OWNER [TASKOWNER]
from
dbo.MKTMARKETINGPLANITEMTASK
where
MKTMARKETINGPLANITEMTASK.OWNERID is null