Bulk RSVP Updates in Elevated Events

In which case this will update the inv_status from 1 (invited) to 3 (accepted) in a particular EE and for a list of customers, if you have someone with SQL knowledge.

Run it in TEST first

1. Replace the XXXX with Campaign Number of the Elevated Event and ZZZZ with the List number (the list containing Constituent IDs of the people you want to change)
   1. The output will let you know who was changed from 1 to 3.
2. If the campaign and constituent IDs in the output table are the ones you want changed, you can run it for real by changing ROLLBACK transaction to COMMIT transaction.
3. In the TEST Tessitura Client have a check that all is aok
4. If all is well replicate steps 1-3 in LIVE 
   
   
   
   

   DECLARE @campaign_no INT = XXXX,
   	@inv_status INT = 1,
   	@NEW_inv_status INT = 3,
   	@List_no INT = ZZZZ;
   
   DECLARE @update_inv_status TABLE 
   	(customer_no INT, Campaign_no INT, OLD_inv_status INT, NEW_inv_status INT);
   
   
   BEGIN TRANSACTION
   
   UPDATE TX_EVENT_EXTRACT
   SET inv_status = @NEW_inv_status
   OUTPUT deleted.customer_no, deleted.campaign_no, deleted.inv_status, inserted.inv_status
   INTO @update_inv_status
   WHERE campaign_no = @campaign_no
       and inv_status = @inv_status
       and customer_no in (SELECT DISTINCT customer_no from T_LIST_CONTENTS WITH (NOLOCK) WHERE list_no = @List_no)
   
   SELECT * FROM @update_inv_status
   
   ROLLBACK TRANSACTION
   
   --Run in TEST first and check your Elevanted Event in client
   --IF returned table is ok change ROLLBACK to COMMIT and rerun