USP_RECORDOPERATION_MERCHANDISEREMOVETAXUPDATE

                create procedure dbo.USP_RECORDOPERATION_MERCHANDISEREMOVETAXUPDATE
                (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier
                )
                as begin
                set nocount on;

                update dbo.MERCHANDISEPRODUCT set
                  TAXID = null,
                  CHANGEDBYID = @CHANGEAGENTID,
                  DATECHANGED = getdate()
                where ID = @ID;

                return 0;

                end