I'd like to update the Performance Description and Short Name for a run of perfs. I know this can't be done in Season Manager, so I thought I'd do it in SSMS, but I can't find the table with this info. It isn't in T_PERF and I feel like I've looked at every other Perf-related table and can't find it. Does anyone know where it lives?
Thanks!Anne RobichauxCRM AdministratorThe Historic New Orleans Collection
T_INVENTORY. JOIN on perf_no = inv_no.
John A. Moskal II
Thank you!
Could you share your script with me? I am literally trying to accomplish the same thing right now?
The inv_no column in T_INVENTORY will give you the perf_no in T_PERF. If you know the perf nos, you can just use those in the script to update T_Inventory, but if not, you can find the perf_codes in T_PERF. It can probably be done in fewer steps but if you just want to look at the perf no, perf code and description, run this:SELECT p.perf_no, p.perf_code, i.inv_no, i.descriptionFROM T_PERF pJOIN T_INVENTORY iON p.perf_no = i.inv_noOnce you know what the inv_no of the perfs you are looking for are (you'll see they match the perf nos)
You can then update in bulk with something like this:
UPDATE T_INVENTORY SET description = ' 'WHERE inv_noYou'll need to put your new description between the single quotes. And you'll need to define which perf nos you are updating. If it is a range, can say WHERE inv_no BETWEEN 10 AND 100. Let me know if that isnt clear.
Anne