total # of constituents

This query will return the number of Active constituents in your T_CUSTOMER table:

select count(*) from t_customer where inactive = 1

Bob

Is there a quick query I can run to produce the total number of constituents we have in our database?

thanks

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 query will return the number of Active constituents in your T_CUSTOMER table:

select count(*) from t_customer where inactive = 1

Bob

Is there a quick query I can run to produce the total number of constituents we have in our database?

thanks

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!