It might just be that time of day where my brain is DONE but...
I have created a view to show consecutive years as a subscriber and we would like this to be an attribute that gets updated on the regular (maybe each season?). I did a quick insert into statement to get the current values in there. I realized when I set up the new attribute in T_KEYWORD there is a ref table, etc. If I enter the parameters I want from my view does this update itself or do I need to do something to update?
Thanks for your help!
Madeline
It does not update dynamically. The reference table columns allow you to define choices for a dropdown that users can select a value from.
Thanks Brian, that makes so much more sense!
So if I want this to be something that gets updated regularly I need to create a procedure to do so?
Hi Madeline,
If it's adding an attribute, you might consider using the Manage Attributes utility in the Data Management folder. We use this - it's scheduled to run each Sunday night (but you might want to schedule it daily) and is based on a Dynamic List.
Martin
Martin,
This would make my life super easy but the attribute value is coming from the custom view I wrote and will be different for each person on the list. That's where I'm hung up. I can go in on the SSMS side and add the attribute with the proper values but would like to figure out how to update this automatically instead of having to add another to-do to my EOFY/BOFY list.
Thanks,
Sounds like a Job for the SQL Server Agent...
This is what I thought...if anyone is well versed in this land I would love to chat and make sure I'm on the right path...
Feel free to ping me. We run a dozen or more. Probably too many.