USP_IDMAPPER_FUNDRAISER_TO_CONSTITUENT

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

            -- write the SQL to fetch @TARGETID based on @SOURCEID

            select
                         @TARGETID = CONSTITUENTID
                  from
                      dbo.FUNDRAISERDATERANGE
                  where
            ID=@SOURCEID

            return 0;