CREATE PROCEDURE [dbo].[MssWebGetSortOrderForTopLevelQuoteItems]
    @inOrderId int,
    @inQuoteId int
as
begin
    set nocount on;

    select QuoteGroupID as [Key], SortOrder as [Value]
    from QuoteGroup
    inner join QuoteHeader on
        QuoteHeader.QuoteHeaderID = QuoteGroup.QuoteHeaderFID and
        QuoteHeader.OrdersFID = @inOrderId
    where
        QuoteGroup.QuoteHeaderFID = @inQuoteId
    order by SortOrder asc
end
GO
GRANT EXECUTE ON  [dbo].[MssWebGetSortOrderForTopLevelQuoteItems] TO [MssExec]
GO