UFN_CONSTITUENT_GETCONSTITUENTSBYCONSTITUENCYCODEID

Gets all constituents that belong to a user-defined constituency

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENCYCODEID	uniqueidentifier	IN

Definition

Copy



        create function dbo.UFN_CONSTITUENT_GETCONSTITUENTSBYCONSTITUENCYCODEID
        (
            @CONSTITUENCYCODEID uniqueidentifier
        )
        returns table
        as return
            select 
                CONSTITUENT.[ID] as [ID]
            from 
                dbo.CONSTITUENCY
                inner join dbo.CONSTITUENT on CONSTITUENT.[ID] = CONSTITUENCY.[CONSTITUENTID]
            where
                CONSTITUENCY.[CONSTITUENCYCODEID] = @CONSTITUENCYCODEID