create procedure [dbo].[MssWebInsertUpdateDeleteSitDiscount]
    @inOrderId int,
    @inDiscount decimal(10,4)
as
begin
    set nocount on;
    merge into SITJointInfo with (tablock)
    using (select @inOrderId as OrderId) as source
        on SITJointInfo.OrdersFId = source.OrderId
    when matched then
        update set SITDiscount = @inDiscount
    when not matched then
        insert (OrdersFId, SITDiscount)
        values (@inOrderId, @inDiscount);
end
GO
GRANT EXECUTE ON  [dbo].[MssWebInsertUpdateDeleteSitDiscount] TO [MssExec]
GO