create procedure [dbo].[MssWebUpdateOrderLocation]
    @inOrderId int,
    @inLocationId int,
    @inOrderLocationAddressTypeId int,
    @inDescription varchar(100),
    @inCrossStreet varchar(1024),
    @inServiceEntrance varchar(1024),
    @inSiteNote varchar(1024),
    @inContactId int,
    @inBuildingId int,
    @inImportedFlag bit
as
begin
    set nocount on;
    update OrderLocations
    set OrderFID = @inOrderId,
        Name = @inDescription,
        OrderLocationAddressTypeFID = @inOrderLocationAddressTypeId,
        CrossStreet = @inCrossStreet,
        ServiceEntrance =@inServiceEntrance,
        SiteNote = @inSiteNote,
        OrderContactFId = @inContactId,
        BuildingFId = @inBuildingId,
        ImportedFlag = @inImportedFlag
    where OrderLocations.OrderFID = @inOrderId and OrderLocations.OrderLocationID = @inLocationId;
end
GO
GRANT EXECUTE ON  [dbo].[MssWebUpdateOrderLocation] TO [MssExec]
GO