USP_SIMPLEDATALIST_CAMPAIGNPRIORITY

This list returns all the priorities associated with a campaign.

Parameters

Parameter	Parameter Type	Mode	Description
@CAMPAIGNID	uniqueidentifier	IN	Campaign

Definition

Copy



        create procedure dbo.USP_SIMPLEDATALIST_CAMPAIGNPRIORITY (
          @CAMPAIGNID uniqueidentifier = null
        ) as begin

            select 
              CAMPAIGNPRIORITY.ID [VALUE],
              CAMPAIGNPRIORITYTYPECODE.DESCRIPTION [LABEL]
          from
              dbo.CAMPAIGNPRIORITY
          left outer join
              dbo.CAMPAIGNPRIORITYTYPECODE on CAMPAIGNPRIORITY.CAMPAIGNPRIORITYTYPECODEID = CAMPAIGNPRIORITYTYPECODE.ID
          where
              CAMPAIGNPRIORITY.CAMPAIGNID = @CAMPAIGNID;    

         end