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

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