UFN_CONSTITUENT_GETVSECONSTITUENTS

            CREATE function dbo.UFN_CONSTITUENT_GETVSECONSTITUENTS
            (
                @STARTDATE datetime = null,
                @ENDDATE datetime = null,
                @EXCLUDEUSAGETYPECODE tinyint = 0
            )
            returns table
            as
            return(
            with VSECOSTITUENTS_CTE as (
                    select distinct
                        VSECONSTITUENCY1.VSECONSTITUENCYCODE,
                        VSECONSTITUENCY1.VSECONSTITUENCY,
                        VSECONSTITUENCY1.TYPECODE,
                        VSECONSTITUENCY1.[TYPE],
                        VSECONSTITUENCY1.SEQUENCE,
                        CONSTITUENTCODE1.CONSTITUENTID,
                        CONSTITUENTCODE1.DATEFROM,
                        CONSTITUENTCODE1.DATETO
                    from 
                        dbo.VSECONSTITUENCYMAP as VSEMAP1 
                        inner join dbo.VSECONSTITUENCY as VSECONSTITUENCY1 on VSECONSTITUENCY1.ID = VSEMAP1.VSECONSTITUENCYID
                        inner join dbo.UFN_REPORT_VALIDCONSCODE(@STARTDATE, @ENDDATE) as CONSTITUENTCODE1 on CONSTITUENTCODE1.ID = VSEMAP1.CONSTITUENCYID
                        inner join dbo.CONSTITUENT as CONSTITUENT1 with (nolock) on CONSTITUENT1.ID = CONSTITUENTCODE1.CONSTITUENTID
                    where 
                        VSECONSTITUENCY1.USAGETYPECODE <> @EXCLUDEUSAGETYPECODE and
                        VSECONSTITUENCY1.TYPECODE = (case when CONSTITUENT1.ISORGANIZATION = 0 then 0 else 1 end)        
                )
                select distinct
                    VSECONSTITUENTS1.VSECONSTITUENCYCODE,
                    VSECONSTITUENTS1.VSECONSTITUENCY,
                    VSECONSTITUENTS1.TYPECODE,
                    VSECONSTITUENTS1.[TYPE],
                    VSECONSTITUENTS1.CONSTITUENTID,
                    VSECONSTITUENTS1.DATEFROM,
                    VSECONSTITUENTS1.DATETO
                from 
                    VSECOSTITUENTS_CTE VSECONSTITUENTS1
                where 
                    VSECONSTITUENTS1.SEQUENCE = (
                        select 
                            min(VSECONSTITUENTS2.SEQUENCE)
                        from 
                            VSECOSTITUENTS_CTE VSECONSTITUENTS2
                        where 
                            VSECONSTITUENTS1.CONSTITUENTID = VSECONSTITUENTS2.CONSTITUENTID)
            )