UFN_SITEID_MAPFROM_NAMINGOPPORTUNITYID

Maps a NAMINGOPPORTUNITYID to a SITEID.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@NAMINGOPPORTUNITYID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_SITEID_MAPFROM_NAMINGOPPORTUNITYID
            (
                @NAMINGOPPORTUNITYID uniqueidentifier
            )
            returns uniqueidentifier
            as
            begin
                declare @SITEID uniqueidentifier;
                select 
                    @SITEID = NAMINGOPPORTUNITY.SITEID
                from dbo.NAMINGOPPORTUNITY 
                where NAMINGOPPORTUNITY.ID = @NAMINGOPPORTUNITYID

                return @SITEID;
            end