USP_IDMAPPER_APPUSER_TO_FUNDRAISER

Parameters

Parameter Parameter Type Mode Description
@SOURCEID uniqueidentifier IN
@TARGETID uniqueidentifier INOUT

Definition

Copy


            create procedure  dbo.USP_IDMAPPER_APPUSER_TO_FUNDRAISER(@SOURCEID uniqueidentifier,@TARGETID uniqueidentifier output)
            as
                set nocount on;

                select
                    @TARGETID = APPUSER.CONSTITUENTID
                from
                    APPUSER
                join FUNDRAISERDATERANGE on FUNDRAISERDATERANGE.CONSTITUENTID = APPUSER.CONSTITUENTID
                where 
                    APPUSER.ID=@SOURCEID

                return 0;