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

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