USP_REPORT_MATCHFINDERBATCHVALIDATIONREPORT
Provides data for the Update Multiple Constituents from MatchFinder Online Validation Report.
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@BATCHID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_REPORT_MATCHFINDERBATCHVALIDATIONREPORT
(
@BATCHID uniqueidentifier
)
as
set nocount on;
select
[MFO].CONSTITUENTID,
[CONSTITUENT].NAME,
MFORGNAME
from dbo.UPDATEMULTIPLECONSTITUENTSFROMMFOBATCH as [MFO]
left join dbo.CONSTITUENT on CONSTITUENT.ID = [MFO].CONSTITUENTID
where [MFO].BATCHID = @BATCHID