create procedure [dbo].[MssWebDeleteOrderLocation]
    @inOrderId int,
    @inLocationId int
as
begin
    set nocount on;

    delete from OrderLocations
    where OrderLocations.OrderFID = @inOrderId and OrderLocations.OrderLocationID = @inLocationId

    update LocServ set OriginOrderLocationFID = null where OriginOrderLocationFID = @inLocationId
    update LocServ set DestinationOrderLocationFID = null where DestinationOrderLocationFID = @inLocationId

end
GO
GRANT EXECUTE ON  [dbo].[MssWebDeleteOrderLocation] TO [MssExec]
GO