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

Determining # records in database

Barbara Pinney
$organization

 

I'm investigating address hygiene services and I'm not sure how to determine how many records are in our database.

Any suggestions? I do not know SQL.

Thanks.

Barbara Pinney

Tulsa Arts Management Consortium

Parents
  • Former Member
    Former Member $organization

    If you are talking about constituent records you can create a list of all constituent numbers greater than 1.  When you generate the list it can tell you how many constituents you have.  If you have the addresses cleaned you may want to not clean all- exclude constituents that have not bought tickets in the last 5 years, exclude board members and people with higher membership levels. It will save you some money and possible heart ache.

     

     

    Jason Song

    IT Manager

    Scottsdale Cultural Council

    P 480.425.5340

    C 480.529.4653

     

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Barbara Pinney
    Sent: Thursday, January 23, 2014 10:19 AM
    To: Jason Song
    Subject: [Tessitura Technical Forum] Determining # records in database

     

     

    I'm investigating address hygiene services and I'm not sure how to determine how many records are in our database.

    Any suggestions? I do not know SQL.

    Thanks.

    Barbara Pinney

    Tulsa Arts Management Consortium




    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
  • Former Member
    Former Member $organization

    If you are talking about constituent records you can create a list of all constituent numbers greater than 1.  When you generate the list it can tell you how many constituents you have.  If you have the addresses cleaned you may want to not clean all- exclude constituents that have not bought tickets in the last 5 years, exclude board members and people with higher membership levels. It will save you some money and possible heart ache.

     

     

    Jason Song

    IT Manager

    Scottsdale Cultural Council

    P 480.425.5340

    C 480.529.4653

     

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Barbara Pinney
    Sent: Thursday, January 23, 2014 10:19 AM
    To: Jason Song
    Subject: [Tessitura Technical Forum] Determining # records in database

     

     

    I'm investigating address hygiene services and I'm not sure how to determine how many records are in our database.

    Any suggestions? I do not know SQL.

    Thanks.

    Barbara Pinney

    Tulsa Arts Management Consortium




    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