UFN_BATCHCONSTITUENTUPDATE_GETCONSTITUENCIES_SYSTEM

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@BATCHCONSTITUENTUPDATEID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_BATCHCONSTITUENTUPDATE_GETCONSTITUENCIES_SYSTEM
            (
                @BATCHCONSTITUENTUPDATEID uniqueidentifier
            )
            returns table
            as
            return
            (
                select
                    ID,
                    CONSTITUENCYCODEID,
                    DATEFROM,
                    DATETO,
                    ORIGINALCONSTITUENCYID
                from
                    dbo.BATCHCONSTITUENTUPDATECONSTITUENCIESSYSTEM
                where
                    BATCHCONSTITUENTUPDATEID = @BATCHCONSTITUENTUPDATEID
            );