create procedure [dbo].[MssWebGetOrderLocationBuildingConstraints]
    @inOrderId int
as
begin
    set nocount on
    select
        Id = OrderLocations.OrderLocationID,
        LocationName = OrderLocations.Name,
        LocationAddress = dbo.BuildAddressCityStateCountryPostalCode
            (
                dbo.BuildAddressFromAddressParts( OrderLocationAddress.Address1, OrderLocationAddress.Address2, OrderLocationAddress.Address3 ),
                OrderLocationAddress.City,
                OrderLocationAddress.State,
                null,
                OrderLocationAddress.PostalCode
            ),
        crossStreet = OrderLocations.crossstreet,
        serviceEntrance = OrderLocations.serviceEntrance,
        siteNote = OrderLocations.siteNote
    from OrderLocations
    left outer join OrderLocationAddress on OrderLocationAddress.OrderLocationFID = OrderLocations.OrderLocationID
    where OrderLocations.OrderFID = @inOrderId    
end
GO
GRANT EXECUTE ON  [dbo].[MssWebGetOrderLocationBuildingConstraints] TO [MssExec]
GO