USP_WPSEARCHHISTORY_GETCONSTITUENTS_ADDFROMXML

/*
Generated by Blackbaud AppFx Platform
Date:  11/11/2014 4:09:33 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE PROCEDURE dbo.USP_WPSEARCHHISTORY_GETCONSTITUENTS_ADDFROMXML 
(
@WPSEARCHHISTORYID uniqueidentifier,
@XML xml
)

as

set nocount on;

-- build a temporary table containing the values from the XML

declare @TempTbl table (
   [CONSTITUENTID] uniqueidentifier,
   [ID] uniqueidentifier)

insert into @TempTbl select 
    [CONSTITUENTID],
    [ID] 
from dbo.UFN_WPSEARCHHISTORY_GETCONSTITUENTS_FROMITEMLISTXML(@XML)

update @TempTbl set ID = newid() where (ID is null) or (ID = '00000000-0000-0000-0000-000000000000');

if @@Error <> 0
    return 1;

-- insert new items

insert into [WPSEARCHHISTORYSELECTEDCONSTITUENT] 
    ([WPSEARCHHISTORYID], 
    [CONSTITUENTID],
    [ID])
select @WPSEARCHHISTORYID, 
    [CONSTITUENTID],
    [ID]
from @TempTbl as [temp]

if @@Error <> 0
    return 2;

return 0;