USP_BBNC_GETNZCITIES

            create procedure dbo.USP_BBNC_GETNZCITIES(@INCLUDEINACTIVE bit)
            as
            set nocount on;

            --Try to find New Zealand if we can

            declare @NZCOUNTRYID uniqueidentifier;

            select top 1 @NZCOUNTRYID = ID 
            from dbo.COUNTRY 
            where DESCRIPTION = 'New Zealand' and ABBREVIATION = 'NZ';

            declare @ONLYACTIVE bit; 
            if @INCLUDEINACTIVE = 1
                set @ONLYACTIVE = 0;
            else
                set @ONLYACTIVE = 1;

            if not @NZCOUNTRYID is null
                if dbo.UFN_GETLISTSORTMETHOD('STATE') = 0
                begin
                    select
                        STATE.ID, BBNCCODETABLEIDMAP.ID as BBNCID, STATE.DESCRIPTION, STATE.ABBREVIATION
                    from dbo.STATE
                    inner join dbo.BBNCCODETABLEIDMAP on BBNCCODETABLEIDMAP.TABLEENTRYID = STATE.ID
                        and BBNCCODETABLEIDMAP.CODETABLECATALOGID = 'FE193125-9AFA-46B8-86BD-E0E1FAB4C32E'
                    where STATE.COUNTRYID = @NZCOUNTRYID
                        and STATE.ACTIVE >= @ONLYACTIVE
                    order by STATE.DESCRIPTION
                end
                else
                begin
                    select
                        STATE.ID, BBNCCODETABLEIDMAP.ID as BBNCID, STATE.DESCRIPTION, STATE.ABBREVIATION
                    from dbo.STATE
                    inner join dbo.BBNCCODETABLEIDMAP on BBNCCODETABLEIDMAP.TABLEENTRYID = STATE.ID
                        and BBNCCODETABLEIDMAP.CODETABLECATALOGID = 'FE193125-9AFA-46B8-86BD-E0E1FAB4C32E'
                    where STATE.COUNTRYID = @NZCOUNTRYID
                        and STATE.ACTIVE >= @ONLYACTIVE
                    order by STATE.SEQUENCE
                end
            else
                if dbo.UFN_GETLISTSORTMETHOD('STATE') = 0
                begin
                    select
                        STATE.ID, BBNCCODETABLEIDMAP.ID as BBNCID, STATE.DESCRIPTION, STATE.ABBREVIATION
                    from dbo.STATE
                    inner join dbo.BBNCCODETABLEIDMAP on BBNCCODETABLEIDMAP.TABLEENTRYID = STATE.ID
                        and BBNCCODETABLEIDMAP.CODETABLECATALOGID = 'FE193125-9AFA-46B8-86BD-E0E1FAB4C32E'
                    where STATE.ACTIVE >= @ONLYACTIVE
                    order by STATE.DESCRIPTION
                end
                else
                begin
                    select
                        STATE.ID, BBNCCODETABLEIDMAP.ID as BBNCID, STATE.DESCRIPTION, STATE.ABBREVIATION
                    from dbo.STATE
                    inner join dbo.BBNCCODETABLEIDMAP on BBNCCODETABLEIDMAP.TABLEENTRYID = STATE.ID
                        and BBNCCODETABLEIDMAP.CODETABLECATALOGID = 'FE193125-9AFA-46B8-86BD-E0E1FAB4C32E'
                    where STATE.ACTIVE >= @ONLYACTIVE
                    order by STATE.SEQUENCE
                end