USP_NFG_GETSITES_ADDFROMXML

create procedure dbo.USP_NFG_GETSITES_ADDFROMXML
(  
    @NFGID uniqueidentifier,  
    @XML xml,  
    @CHANGEAGENTID uniqueidentifier = null,  
    @CHANGEDATE datetime = null  
)  
as
  set nocount on;  

    -- do work

  if @CHANGEAGENTID is null  
      exec USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output  

  if @CHANGEDATE is null  
   set @CHANGEDATE = getdate()  

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

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

  insert into @TempTbl 
   select   
           [ID],  
           [SITEID]   
  from dbo.UFN_EVENT_GETSITES_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 [FAFNFGCampaignDisplaySite]   
     (
       NFGCAMPAIGNID,   
       [ID],  
       [SITEID],      
       ADDEDBYID,   
       CHANGEDBYID,   
       DATEADDED,   
       DATECHANGED)  
  select 
       @NFGID,   
       [ID],  
       [SITEID],   
       @CHANGEAGENTID,   
       @CHANGEAGENTID,   
       @CHANGEDATE,   
       @CHANGEDATE  
  from @TempTbl as [temp]  

  if @@Error <> 0  
     return 2;  

  return 0;