USP_REVENUEREFERENCE_ADD

    CREATE procedure dbo.USP_REVENUEREFERENCE_ADD
    (
        @REVENUEID uniqueidentifier,
        @REFERENCE nvarchar(255),
        @CHANGEAGENTID uniqueidentifier
    )
    as
    begin
        set nocount on;

        declare @CURRENTDATE datetime;

        set @CURRENTDATE = GetDate();

        if @CHANGEAGENTID is null
            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

        begin try
            if not @REFERENCE is null and @REFERENCE <> ''
                begin
                    --if not exists(select ID from dbo.REVENUEREFERENCE where ID = @REVENUEID)                        

                        --insert into dbo.REVENUEREFERENCE (ID, REFERENCE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)

                            --values (@REVENUEID, @REFERENCE, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE);

           update dbo.REVENUE_EXT
           set REFERENCE = ISNULL(@REFERENCE, ''),
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED= @CURRENTDATE
           where ID = @REVENUEID
                end
        end try
        begin catch
            exec dbo.USP_RAISE_ERROR;
            return 1;
        end catch

        return 0;
    end