• Replies 8 replies
  • Subscribers 338 subscribers
  • Views 174 views
  • Users 0 members are here
Related

Query to find people who attended a performance in a production more than once

Tiffany Elliott (Past Member)
$organization

Hi Tess friends,

I'm attempting to write a query to find patrons who have attended a performance in a production season more than once (a repeat buyer) and I'm having a heck of a time finding the table/view that I should be using.

At first, I thought it had to do with 'vs_tkt_hist" as that came up when I was experimenting in list builder, but I don't see that table anywhere in SSMS. 

Does anyone have any recommendations as to what table I should use?  Any idea what I might be doing wrong? Any help would be greatly appreciated. :)

 

Thanks,

Tiffany Evans

Database Coordinator

Huntington Theatre Company

Parents
  • $organization

    Thanks Wendell,

     

    I think the problem is, there is no vs_tkt_hist anymore…

    I also don’t see the table LT_TKT_HIST.

     

     

    I only see vs_tck_hist and it doesn’t have a column for perf_no, only performance_name and performance_dt.

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Wendell Baskin
    Sent: Monday, September 30, 2013 4:53 PM
    To: Tiffany Evans
    Subject: RE: [Tessitura Technical Forum] Query to find people who attended a performance in a production more than once

     

     

     

    vs_tkt_hist is a view and not a table.  In SMSS, expand Views and you should see it.

    A view or table can be used in a Select statement.

     

    You can also try the table LT_TKT_HIST.

     

     

    Good Luck

    Wendell Baskin

    Bass Hall – Fort Worth

     

     

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Tiffany Evans
    Sent: Monday, September 30, 2013 15:35
    To: Wendell Baskin
    Subject: [Tessitura Technical Forum] Query to find people who attended a performance in a production more than once

     

    Hi Tess friends,

    I'm attempting to write a query to find patrons who have attended a performance in a production season more than once (a repeat buyer) and I'm having a heck of a time finding the table/view that I should be using.

    At first, I thought it had to do with 'vs_tkt_hist" as that came up when I was experimenting in list builder, but I don't see that table anywhere in SSMS. 

    Does anyone have any recommendations as to what table I should use?  Any idea what I might be doing wrong? Any help would be greatly appreciated. :)

     

    Thanks,

    Tiffany Evans

    Database Coordinator

    Huntington Theatre Company




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Reply
  • $organization

    Thanks Wendell,

     

    I think the problem is, there is no vs_tkt_hist anymore…

    I also don’t see the table LT_TKT_HIST.

     

     

    I only see vs_tck_hist and it doesn’t have a column for perf_no, only performance_name and performance_dt.

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Wendell Baskin
    Sent: Monday, September 30, 2013 4:53 PM
    To: Tiffany Evans
    Subject: RE: [Tessitura Technical Forum] Query to find people who attended a performance in a production more than once

     

     

     

    vs_tkt_hist is a view and not a table.  In SMSS, expand Views and you should see it.

    A view or table can be used in a Select statement.

     

    You can also try the table LT_TKT_HIST.

     

     

    Good Luck

    Wendell Baskin

    Bass Hall – Fort Worth

     

     

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Tiffany Evans
    Sent: Monday, September 30, 2013 15:35
    To: Wendell Baskin
    Subject: [Tessitura Technical Forum] Query to find people who attended a performance in a production more than once

     

    Hi Tess friends,

    I'm attempting to write a query to find patrons who have attended a performance in a production season more than once (a repeat buyer) and I'm having a heck of a time finding the table/view that I should be using.

    At first, I thought it had to do with 'vs_tkt_hist" as that came up when I was experimenting in list builder, but I don't see that table anywhere in SSMS. 

    Does anyone have any recommendations as to what table I should use?  Any idea what I might be doing wrong? Any help would be greatly appreciated. :)

     

    Thanks,

    Tiffany Evans

    Database Coordinator

    Huntington Theatre Company




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Children
No Data