USP_BBWORKFLOW_WORKFLOWTASKDATAITEM_SETVALUE

create procedure dbo.USP_BBWORKFLOW_WORKFLOWTASKDATAITEM_SETVALUE
(
    @BBWORKFLOWTASKID uniqueidentifier,
    @ITEMKEY nvarchar(255),
    @DATAITEM nvarchar(max),
    @CHANGEAGENTID uniqueidentifier = null
)
as
    /*
    Associates the xml data with the given workflow task using the key provided.
    (Adds or updates a row in dbo.BBWORKFLOWTASKDATAITEM).
    */

    set nocount on;

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

    declare @currentDate datetime;
    set @currentDate = getdate();

    declare @id uniqueidentifier;
    select @id = ID 
        from dbo.BBWORKFLOWTASKDATAITEM 
        where (BBWORKFLOWTASKID = @BBWORKFLOWTASKID) and (ITEMKEY = @ITEMKEY);

    if @id is not null 
        begin
            update dbo.BBWORKFLOWTASKDATAITEM set 
                DATAITEM = @DATAITEM,
                CHANGEDBYID = @CHANGEAGENTID,
                DATECHANGED = @currentDate 
            where ID = @ID
        end

    else
        insert into dbo.BBWORKFLOWTASKDATAITEM
            (BBWORKFLOWTASKID, ITEMKEY, DATAITEM, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
        values 
            (@BBWORKFLOWTASKID, @ITEMKEY, @DATAITEM, @CHANGEAGENTID, @CHANGEAGENTID, @currentDate, @currentDate);