create procedure dbo.MssWebGetAccountingCustomerBillToAddresses
    @inAccountingCustomerId int
as
begin
    set nocount on
    select
        AddressType = AccountingCustomerAddressType.TypeName,
        Contact = AccountingCustomer.Contact,
        Address1 = AccountingCustomerAddress.Address1,
        Address2 = AccountingCustomerAddress.Address2,
        Address3 = AccountingCustomerAddress.Address3,
        City = AccountingCustomerAddress.City,
        State = AccountingCustomerAddress.State,
        PostalCode = AccountingCustomerAddress.PostalCode,
        Country = CountryCodeStandard.CountryName
    from AccountingCustomerAddress
    
    left outer join AccountingCustomer
        on AccountingCustomerAddress.AccountingCustomerFid = AccountingCustomer.AccountingCustomerId
    left outer join CountryCodeStandard
        on AccountingCustomerAddress.CountryCodeStandardFID = CountryCodeStandard.CountryCodeStandardID
    left outer join AccountingCustomerAddressType
        on AccountingCustomerAddress.AccountingCustomerAddressTypeFid = AccountingCustomerAddressType.AccountingCustomerAddressTypeId
    
    where
        AccountingCustomerAddress.AccountingCustomerAddressId = @inAccountingCustomerId
    
    order by
        AccountingCustomerAddressType.TypeName
end
GO
GRANT EXECUTE ON  [dbo].[MssWebGetAccountingCustomerBillToAddresses] TO [MssExec]
GO