UFN_RECORDOPERATION_TASKREFERENCES

CREATE function dbo.UFN_RECORDOPERATION_TASKREFERENCES
(
    @RECORDOPERATIONID uniqueidentifier
)
returns @TABLE table
(
    TASKID uniqueidentifier
)
with execute as caller
as
begin

    -- find pages with page actions that use this data form instance

    with xmlnamespaces ('bb_appfx_task' as tns, 'bb_appfx_commontypes' as common)
    insert into @TABLE
        select T.ID
        from dbo.TASKCATALOG as T
        where T.TASKSPECXML.value('(tns:TaskSpec/common:ExecuteRecordOperation/@RecordOperationID)[1]', 'uniqueidentifier') = @RECORDOPERATIONID;

    return;

end;