UFN_BATCHCONSTITUENTUPDATE_GETSITES

Returns all sites for a given batch constituent update record.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHCONSTITUENTUPDATEID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_BATCHCONSTITUENTUPDATE_GETSITES(
    @BATCHCONSTITUENTUPDATEID uniqueidentifier
) returns table
as
return
(
    select
        ID,
        SITEID
    from
        dbo.BATCHCONSTITUENTUPDATESITES
    where
        BATCHCONSTITUENTUPDATEID = @BATCHCONSTITUENTUPDATEID
);