USP_ADDRESS_GETGEOCODEFIELDS

            create procedure dbo.USP_ADDRESS_GETGEOCODEFIELDS(@ADDRESSID uniqueidentifier)
            as
                set nocount on;

                select
                    ADDRESS.ADDRESSBLOCK,
                    ADDRESS.CITY,
                    coalesce(STATE.ABBREVIATION, '') [STATE],
                    ADDRESS.POSTCODE,
                    coalesce(COUNTRY.ABBREVIATION, '') [COUNTRY]
                from
                    dbo.ADDRESS
                left join
                    dbo.STATE on STATE.ID = ADDRESS.STATEID
                left join
                    dbo.COUNTRY on COUNTRY.ID = ADDRESS.COUNTRYID
                where
                    ADDRESS.ID = @ADDRESSID;