USP_SIMPLEDATALIST_VSECONSTITUENCY

CREATE procedure dbo.USP_SIMPLEDATALIST_VSECONSTITUENCY(@VSECONSTITUENCYID uniqueidentifier = null)
as
    select
    CONSTITUENCYDEFINITION.ID as VALUE,
    CONSTITUENCYDEFINITION.DESCRIPTION as LABEL
from
    dbo.CONSTITUENCYDEFINITION
where
    CONSTITUENCYDEFINITION.ID <> '55FE8E7C-2B68-44C8-B35C-818AD1944C03' --JamesWill WI168623 2011-08-01 Remove Community Member Constituency

    and CONSTITUENCYDEFINITION.ISACTIVE = 1
    and
    (
        CONSTITUENCYDEFINITION.ID in (select CONSTITUENCYID from VSECONSTITUENCYMAP where VSECONSTITUENCYID = @VSECONSTITUENCYID) 
        or CONSTITUENCYDEFINITION.ID not in (select CONSTITUENCYID from VSECONSTITUENCYMAP where VSECONSTITUENCYID <> @VSECONSTITUENCYID)
    )
order by LABEL