UFN_CONSTITUENTID_MAPFROM_PROSPECTTEAMID

Maps an PROSPECTTEAMID to a CONSTITUENTID

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@PROSPECTTEAMID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_CONSTITUENTID_MAPFROM_PROSPECTTEAMID(@PROSPECTTEAMID uniqueidentifier) 
            returns uniqueidentifier
            as
            begin
                declare @ID uniqueidentifier;

                select
                    @ID = PROSPECTTEAM.PROSPECTID
                from
                    dbo.PROSPECTTEAM
                where
                    PROSPECTTEAM.ID = @PROSPECTTEAMID;

                return @ID;
            end