UFN_SITEID_MAPFROM_NAMINGOPPORTUNITYRECOGNITIONID

            create function dbo.UFN_SITEID_MAPFROM_NAMINGOPPORTUNITYRECOGNITIONID
            (
                @NAMINGOPPORTUNITYRECOGNITIONID uniqueidentifier
            )
            returns uniqueidentifier
            as
            begin
                declare @SITEID uniqueidentifier;
                select 
                    @SITEID = NAMINGOPPORTUNITY.SITEID
                from dbo.NAMINGOPPORTUNITYRECOGNITION
                inner join dbo.NAMINGOPPORTUNITY on NAMINGOPPORTUNITY.ID = NAMINGOPPORTUNITYRECOGNITION.NAMINGOPPORTUNITYID
                where NAMINGOPPORTUNITYRECOGNITION.ID = @NAMINGOPPORTUNITYRECOGNITIONID

                return @SITEID;
            end