USP_GET_ALL_COUNTRYADDRESSFORMAT

CREATE PROCEDURE dbo.USP_GET_ALL_COUNTRYADDRESSFORMAT
AS BEGIN                     
    SELECT CF.FORMATSTRING AS AddressFormat ,C.[Description] AS SelectedCountry 
    FROM dbo.COUNTRYADDRESSFORMAT AS CF
    INNER JOIN dbo.COUNTRY AS C ON C.COUNTRYADDRESSFORMATID = CF.ID
    WHERE C.ACTIVE = 1
END