CREATE PROCEDURE [dbo].[MssWebUpdateQuoteHeader]
    @inOrderId int,
    @inQuoteId int,

    @Description varchar(64) = null,
    @UpdateDescription bit = 0,

    @QuoteStatusFID int = null,
    @UpdateQuoteStatusFID bit = 0,

    @OrderContactFID int = null,
    @UpdateOrderContactFID bit = 0
as
begin
    set nocount on;

    update QuoteHeader
    set
        Description = case when @UpdateDescription = 1 then @Description else Description end,
        QuoteStatusFID = case when @UpdateQuoteStatusFID = 1 then @QuoteStatusFID else QuoteStatusFID end,
        OrderContactFID = case when @UpdateOrderContactFID = 1 then @OrderContactFID else OrderContactFID end
    where QuoteHeaderID = @inQuoteId
        and OrdersFID = @inOrderId;
end;
GO
GRANT EXECUTE ON  [dbo].[MssWebUpdateQuoteHeader] TO [MssExec]
GO