USP_SALESORDERITEM_REMOVEFEES

        CREATE procedure dbo.USP_SALESORDERITEM_REMOVEFEES
        (
            @ID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier = null,
            @CURRENTDATE datetime = null
        )
        as
        begin
            set nocount on;
            if @CHANGEAGENTID is null  
                exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

            set @CURRENTDATE = getdate()

            declare @contextCache varbinary(128);
            declare @e int;
            -- cache current context information 

            set @contextCache = CONTEXT_INFO();
            -- set CONTEXT_INFO to @CHANGEAGENTID 

            if not @CHANGEAGENTID is null
                set CONTEXT_INFO @CHANGEAGENTID;

            delete from dbo.[SALESORDERITEM]
            where ID in (select ID from dbo.SALESORDERITEMFEE where SALESORDERITEMID = @ID);

            select @e=@@error;
            -- reset CONTEXT_INFO to previous value 

            if not @contextCache is null
                set CONTEXT_INFO @contextCache;                        
            if @e <> 0
                return 1;
        end