USP_DATALIST_REVENUEBATCHDEFAULTCAMPAIGNS

Returns the default campaigns for a revenue batch record.
Parameters

Parameter	Parameter Type	Mode	Description
@DESIGNATIONID	uniqueidentifier	IN	Designation
@DATE	datetime	IN	Date
Definition

Copy


                    CREATE procedure dbo.USP_DATALIST_REVENUEBATCHDEFAULTCAMPAIGNS
                    (
                        @DESIGNATIONID uniqueidentifier,
                        @DATE datetime
                    )
                    as
                        set nocount on

                        select
                            CAMPAIGNDESIGNATION.CAMPAIGNID,
                            CAMPAIGNDESIGNATION.CAMPAIGNSUBPRIORITYID,
                            CAMPAIGN.USERID,
                            case 
                                when CAMPAIGNPRIORITYTYPECODE.DESCRIPTION is not null and CAMPAIGNSUBPRIORITYNAMECODE.DESCRIPTION is not null then CAMPAIGNPRIORITYTYPECODE.DESCRIPTION + ' - ' + CAMPAIGNSUBPRIORITYNAMECODE.DESCRIPTION
                                else null
                            end CAMPAIGNSUBPRIORITYNAME
                        from dbo.UFN_DESIGNATION_GETCAMPAIGNSTODEFAULT(  @DESIGNATIONID,
                                                                         @DATE) as CAMPAIGNDESIGNATION
                        inner join dbo.CAMPAIGN on CAMPAIGNDESIGNATION.CAMPAIGNID = CAMPAIGN.ID
                        left join dbo.CAMPAIGNSUBPRIORITY on CAMPAIGNSUBPRIORITY.ID = CAMPAIGNDESIGNATION.CAMPAIGNSUBPRIORITYID
                        left join dbo.CAMPAIGNPRIORITY on CAMPAIGNSUBPRIORITY.CAMPAIGNPRIORITYID = CAMPAIGNPRIORITY.ID
                        left join dbo.CAMPAIGNPRIORITYTYPECODE on CAMPAIGNPRIORITY.CAMPAIGNPRIORITYTYPECODEID = CAMPAIGNPRIORITYTYPECODE.ID
                        left join dbo.CAMPAIGNSUBPRIORITYNAMECODE on CAMPAIGNSUBPRIORITY.CAMPAIGNSUBPRIORITYNAMECODEID = CAMPAIGNSUBPRIORITYNAMECODE.ID