UFN_SITEID_MAPFROM_CAMPAIGNID

Maps a CAMPAIGNID to a SITEID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@CAMPAIGNID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_SITEID_MAPFROM_CAMPAIGNID  
            (  
            @CAMPAIGNID uniqueidentifier  
            )  
            returns table
            as
            return  
                select CAMPAIGNSITE.SITEID  
                from dbo.CAMPAIGN
                left outer join dbo.CAMPAIGNSITE on CAMPAIGN.ID = CAMPAIGNSITE.CAMPAIGNID
                where CAMPAIGN.ID = @CAMPAIGNID;