USP_DATALIST_CONSTITUENCYALL

CREATE procedure dbo.USP_DATALIST_CONSTITUENCYALL
(
    @INCLUDEINACTIVE bit = 1
)
as
    set nocount on;

    select 
        ID,
        SYSTEMDESCRIPTION,
        DESCRIPTION as DISPLAYNAME,
        SEQUENCE,
        ISSYSTEM as ISSYSTEMCONSTITUENCY,
        ISACTIVE
    from 
        dbo.V_CONSTITUENCYDISPLAYORDER
    where
        (ISACTIVE = 1 or @INCLUDEINACTIVE = 1)
    order by 
        SEQUENCE, DISPLAYNAME