• Replies 9 replies
  • Subscribers 415 subscribers
  • Views 22 views
  • Users 0 members are here
Related

Inactivating Price Maps

Becci Brace
$organization

I am curious to know if anyone inactivates price maps from past performances.  If so, do you do this per season, or after the show closes? Pros?  Cons?

I can only see pros in my corner:

  • Less clutter
  • Our naming convention for maps includes a 2 letter acromyn for the show, sometimes we get duplicates across the years

 

Parents
  • $organization

    Funny you should ask: I was just running the following in SQL Server Management Studio:

     

    update T_PMAP set inactive = 'Y'

    where inactive = 'N' and description like '13%' replace with appropriate zone maps

     

    Obviously, you need to get the description and zone maps that are appropriate for your database.

     

    Lucie

    ______________________________
    Lucie Spieler
    IT Development and Training Manager

    FLORIDA GRAND opera

Reply
  • $organization

    Funny you should ask: I was just running the following in SQL Server Management Studio:

     

    update T_PMAP set inactive = 'Y'

    where inactive = 'N' and description like '13%' replace with appropriate zone maps

     

    Obviously, you need to get the description and zone maps that are appropriate for your database.

     

    Lucie

    ______________________________
    Lucie Spieler
    IT Development and Training Manager

    FLORIDA GRAND opera

Children
No Data