USP_SIMPLELIST_CAMPAIGNTEAM
This simple list returns all of the campaigns that an organizational team is associated with.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ORGTEAMIDSET | uniqueidentifier | IN | Org team ID set |
Definition
Copy
create procedure dbo.USP_SIMPLELIST_CAMPAIGNTEAM (
@ORGTEAMIDSET uniqueidentifier
) as begin
select
CAMPAIGN.ID [VALUE],
CAMPAIGN.NAME [LABEL]
from
dbo.CAMPAIGNTEAM
left outer join
dbo.CAMPAIGN on CAMPAIGNTEAM.CAMPAIGNID = CAMPAIGN.ID
where
CAMPAIGNTEAM.ORGTEAMIDSET = @ORGTEAMIDSET
end