• Replies 4 replies
  • Subscribers 337 subscribers
  • Views 87 views
  • Users 0 members are here
Related

Which table has Perf Description and Short Name?

Anne M Robichaux
$organization

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 Robichaux
CRM Administrator
The Historic New Orleans Collection

Parents
  • $organization

    Could you share your script with me? I am literally trying to accomplish the same thing right now?

  • $organization in reply to NaKeisha Wyatt

    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.description
    FROM T_PERF p
    JOIN T_INVENTORY i
    ON p.perf_no = i.inv_no

    Once 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_no

    You'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

Reply
  • $organization in reply to NaKeisha Wyatt

    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.description
    FROM T_PERF p
    JOIN T_INVENTORY i
    ON p.perf_no = i.inv_no

    Once 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_no

    You'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

Children
No Data