UFN_CONSITTID_MAPFROM_CONSTITSOLICITCODEID

Maps a constituent solicit code ID to a constituent ID

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITSOLICITCODEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_CONSITTID_MAPFROM_CONSTITSOLICITCODEID(@CONSTITSOLICITCODEID uniqueidentifier) 
            returns uniqueidentifier
            as
            begin

                DECLARE @ID uniqueidentifier;

                SELECT @ID=CONSTITUENTID from dbo.CONSTITUENTSOLICITCODE where ID=@CONSTITSOLICITCODEID;

                RETURN @ID;

            end