USP_COUNTRY_DATALIST

CREATE procedure dbo.USP_COUNTRY_DATALIST
(
    @INCLUDEINACTIVE bit = 0
)
as
set nocount on;

if @INCLUDEINACTIVE = 0 
    select 
        COUNTRY.ID, 
        COUNTRY.DESCRIPTION, 
        COUNTRY.ABBREVIATION,
        COUNTRYADDRESSFORMAT.FORMATNAME,
        COUNTRY.ACTIVE,
        case when [I].[ID] is null then 0 else 1 end [DEFAULT],
        COUNTRY.COUNTRYCODE,
      dbo.UFN_PHONEFORMATCODE_GETFORMAT(COUNTRY.PHONEFORMATCODE) as PHONEFORMAT,
        COUNTRY.ISO3166,
    COUNTRY.PHONEFORMATCODE
    from 
        dbo.COUNTRY
        inner join dbo.COUNTRYADDRESSFORMAT on COUNTRYADDRESSFORMAT.ID = COUNTRY.COUNTRYADDRESSFORMATID
        left outer join dbo.[INTERNATIONALIZATIONINFO] [I] on [COUNTRY].[ID] = [I].[DEFAULTCOUNTRYID]
    where 
        COUNTRY.ACTIVE = 1
    order by 
        COUNTRY.DESCRIPTION;
else
    select 
        COUNTRY.ID, 
        COUNTRY.DESCRIPTION, 
        COUNTRY.ABBREVIATION,
        COUNTRYADDRESSFORMAT.FORMATNAME,
        COUNTRY.ACTIVE,
        case when [I].[ID] is null then 0 else 1 end [DEFAULT],
        COUNTRY.COUNTRYCODE,
        dbo.UFN_PHONEFORMATCODE_GETFORMAT(COUNTRY.PHONEFORMATCODE) as PHONEFORMAT,
        COUNTRY.ISO3166,
    COUNTRY.PHONEFORMATCODE
    from 
        dbo.COUNTRY
        inner join dbo.COUNTRYADDRESSFORMAT on COUNTRYADDRESSFORMAT.ID = COUNTRY.COUNTRYADDRESSFORMATID
          left outer join dbo.[INTERNATIONALIZATIONINFO] [I] on [COUNTRY].[ID] = [I].[DEFAULTCOUNTRYID]
    order by 
        COUNTRY.DESCRIPTION