CREATE PROCEDURE [dbo].[MssWebResequenceQuoteGroupSortOrder]
(
    @inQuoteId int
)
as
begin
    set nocount on;

    update QuoteGroup
    set SortOrder = Resequenced.NewSortOrder
    from QuoteGroup
    inner join (
        select
            QuoteGroupID,
            row_number() over (order by SortOrder, QuoteGroupID desc) as NewSortOrder
        from QuoteGroup
        where QuoteHeaderFID = @inQuoteId
    ) Resequenced
        on QuoteGroup.QuoteGroupID = Resequenced.QuoteGroupID;
end
GO
GRANT EXECUTE ON  [dbo].[MssWebResequenceQuoteGroupSortOrder] TO [MssExec]
GO