UFN_PROSPECTID_MAPFROM_PROSPECTPLANID

Maps a PROSPECTPLANID to a PROSPECTID

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@PROSPECTPLANID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_PROSPECTID_MAPFROM_PROSPECTPLANID(@PROSPECTPLANID uniqueidentifier) 
            returns uniqueidentifier
            as
            begin
                declare @ID uniqueidentifier;

                select
                    @ID = PROSPECTPLAN.PROSPECTID
                from
                    dbo.PROSPECTPLAN
                where
                    PROSPECTPLAN.ID = @PROSPECTPLANID;

                return @ID;
            end