CREATE PROCEDURE [dbo].[MssWebUpdateSortOrderForTopLevelQuoteItems]
    @inOrderId int,
    @inQuoteId int,
    @inLineItemSortOrders PriKeyToIntMap readonly
as
begin
    set nocount on;

    update QuoteGroup
    set SortOrder = SortOrders.Value
    from @inLineItemSortOrders SortOrders
    inner join QuoteGroup on QuoteGroup.QuoteGroupID = SortOrders.Id and
               QuoteGroup.QuoteHeaderFID = @inQuoteId
    inner join QuoteHeader on
        QuoteHeader.QuoteHeaderID = QuoteGroup.QuoteHeaderFID and
        QuoteHeader.QuoteHeaderID = @inQuoteId and
        QuoteHeader.OrdersFID = @inOrderId;
end
GO
GRANT EXECUTE ON  [dbo].[MssWebUpdateSortOrderForTopLevelQuoteItems] TO [MssExec]
GO