USP_ADHOCQUERY_UPDATEIDSETREGISTERDEPENDENCY

create procedure [dbo].[USP_ADHOCQUERY_UPDATEIDSETREGISTERDEPENDENCY] ( @ADHOCQUERYID uniqueidentifier )
as
set nocount on;

delete [dbo].[ADHOCQUERYIDSETDEPENDENCY] where [ADHOCQUERYID] = @ADHOCQUERYID;

with XMLNAMESPACES 
(
  'Blackbaud.AppFx.WebService.API.1' as q
)
insert into dbo.ADHOCQUERYIDSETDEPENDENCY(ADHOCQUERYID, IDSETREGISTERID, ADHOCQUERYDEPENDENCYID)
  select distinct
    ADHOCQUERY.ID [ADHOCQUERYID],
    T.c.value('.', 'uniqueidentifier') [IDSETREGISTERID],
    IDSETREGISTERADHOCQUERY.ADHOCQUERYID
  from dbo.ADHOCQUERY
  cross apply QUERYDEFINITIONXML.nodes('q:AdHocQuery/*/q:f/q:IDSetFieldInfo/q:ID') as T(c) 
  inner join dbo.IDSETREGISTER on IDSETREGISTER.ID = T.c.value('.', 'uniqueidentifier')
  inner join dbo.IDSETREGISTERADHOCQUERY on IDSETREGISTERADHOCQUERY.IDSETREGISTERID = IDSETREGISTER.ID
  where ADHOCQUERY.ID = @ADHOCQUERYID;