Hi all,
Does anyone know of a quick way of updating Constituent Interests based on a list? At the Royal Exchange, we have a list of people who have signed up to email in an external email system and we'd like the Constituent Interests for Data Protection to reflect that.
I've created them as a List in Tessitura so hoped there would be a handy update report (similar to the 'adding an attribute' one). If not, would anyone be happy to share the sql? With Ean Burgon, the only other similar example we found was much more complicated than we need (http://www.tessituranetwork.com/COMMUNITY/forums/t/4082.aspx).
The logic of what we're trying to do is: add a tick to Email_Yes (one of our Constituent Interests) based on a list but leave all the other Constituent Interests the same. It's the logic of 'adding new rows' to the tx_cust_tkw that we're struggling with.
Thanks
Mary
I know this is an old thread, but I saw that people have responded recently and seem happy with this bit of SQL. I'm having a bit of trouble with the end of the query that checks to make sure the constituent doesn't already have the interests. This bit is giving me an error in SQL Server Management.
The query works just fine when I remove that section and setup my list to remove people who already have the keyword. This is fine, but I would prefer to avoid setting up all of my list like that in the future.
Any advice on this is greatly appreciated. Thanks.
Is it because the code pasted in Mary's forum post is missing the last paren?