What is a quick query I can run to find out the total numebr of active constituents in our database?
Try this:
use impresario
select count(*) from t_customer where inactive = (select id from tr_cust_inactive where description = 'active')
hope it helps.
Jeff
Great- thanks!