USP_SIMPLELIST_DESIGNATIONCAMPAIGN
This simple list returns all of the default campaigns for a
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DESIGNATIONID | uniqueidentifier | IN | Purpose |
| @ASOFDATE | datetime | IN | As of date |
Definition
Copy
create procedure dbo.USP_SIMPLELIST_DESIGNATIONCAMPAIGN (
@DESIGNATIONID uniqueidentifier = null,
@ASOFDATE datetime = null
) as begin
if @ASOFDATE is null
set @ASOFDATE = getdate();
select
CAMPAIGN.ID [VALUE],
CAMPAIGN.USERID [LABEL]
from
dbo.DESIGNATIONCAMPAIGN
left outer join
dbo.CAMPAIGN on DESIGNATIONCAMPAIGN.CAMPAIGNID = CAMPAIGN.ID
where
DESIGNATIONCAMPAIGN.DESIGNATIONID = @DESIGNATIONID
and
((DESIGNATIONCAMPAIGN.DATEFROM is null) or (DESIGNATIONCAMPAIGN.DATEFROM <= @ASOFDATE))
and
((DESIGNATIONCAMPAIGN.DATETO is null) or (DESIGNATIONCAMPAIGN.DATETO >= @ASOFDATE))
end