UFN_SITEID_MAPFROM_FUNDINGPLANMEDIALINKID

Maps a funding plan media link ID to a site ID

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@FUNDINGPLANMEDIALINKID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_SITEID_MAPFROM_FUNDINGPLANMEDIALINKID
            (
                @FUNDINGPLANMEDIALINKID uniqueidentifier
            )
            returns uniqueidentifier
            as
            begin

            declare @SITEID uniqueidentifier

            select 
                @SITEID = FUNDINGPLAN.SITEID
            from 
                dbo.FUNDINGPLAN
                inner join dbo.FUNDINGPLANMEDIALINK on FUNDINGPLANMEDIALINK.FUNDINGPLANID = FUNDINGPLAN.ID
            where 
                FUNDINGPLANMEDIALINK.ID = @FUNDINGPLANMEDIALINKID;

            return @SITEID;

            end