UFN_ADDRESSPROCESS_ALTERNATEADDRESSES

CREATE function dbo.UFN_ADDRESSPROCESS_ALTERNATEADDRESSES(
    @ADDRESSTYPECODEID uniqueidentifier,
    @ADDRESSISPRIMARY bit    
)
returns table
as
return(
    select
        ADDRESS.CONSTITUENTID,
        ADDRESS.ID as ADDRESSID
    from dbo.ADDRESS
    where @ADDRESSISPRIMARY = 0
        and ADDRESS.DONOTMAIL = 0 
        and ADDRESS.ADDRESSTYPECODEID = @ADDRESSTYPECODEID
        and ADDRESS.SEQUENCE = (
            select min(B.SEQUENCE)
            from dbo.ADDRESS B
            where B.CONSTITUENTID = ADDRESS.CONSTITUENTID 
                and B.DONOTMAIL = 0 
                and B.ADDRESSTYPECODEID = @ADDRESSTYPECODEID 
        )

    union all

    select
        ADDRESS.CONSTITUENTID,
        ADDRESS.ID as ADDRESSID
    from dbo.ADDRESS
    where @ADDRESSISPRIMARY = 1
        and ADDRESS.DONOTMAIL = 0 
        and ADDRESS.ISPRIMARY = 1 
)