UFN_CONSTITUENTUPDATEBATCH_GETCONSTITUENCIES

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHCONSTITUENTUPDATEID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_CONSTITUENTUPDATEBATCH_GETCONSTITUENCIES
(
        @BATCHCONSTITUENTUPDATEID uniqueidentifier
)
returns table
as
return
(
        select
                ID,
                CONSTITUENCYCODEID,
                DATEFROM,
                DATETO,
                0 as ISSYSTEM
        from 
                dbo.BATCHCONSTITUENTUPDATECONSTITUENCIES
        where 
                BATCHCONSTITUENTUPDATEID = @BATCHCONSTITUENTUPDATEID
        union all
        select
                ID,
                CONSTITUENCYCODEID,
                DATEFROM,
                DATETO,
                1 as ISSYSTEM
        from 
                dbo.BATCHCONSTITUENTUPDATECONSTITUENCIESSYSTEM
        where 
                BATCHCONSTITUENTUPDATEID = @BATCHCONSTITUENTUPDATEID
);