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;