UFN_EXPORTDEFINITION_IDSETINUSE

create function dbo.[UFN_EXPORTDEFINITION_IDSETINUSE]
(
  @IDSETREGISTERID uniqueidentifier,
  @EXPORTDEFINITIONXML xml
)
returns bit
as
begin
  declare @ID uniqueidentifier;
  declare @RESULT bit = 0;

  select @ID = T.c.value('(ID)[1]', 'uniqueidentifier') 
  from @EXPORTDEFINITIONXML.nodes('ExportDefinitionQueryViewNode//f/IDSetFieldInfo') as T(c) 
  where T.c.value('(ID)[1]', 'uniqueidentifier') = @IDSETREGISTERID;

  if @ID is not null set @RESULT = 1;

  return @RESULT;
end;