Does anyone know how to pull the number of years the members in a membership level have had membership (including memberships given as a benefit of sponsorship and non-consecutive years of membership)?
Our organization would like to print a listing of members of our highest level of membership and group them by the number of years they have had a membership at that level. In the past, this was done manually and took several days to complete. Has anyone attempted this successfully in Tess?
Hi Travis,
We will try it. Thank you for your quick response!
From: Tessitura Memberships [mailto:forums-memberships@tessituranetwork.com] On Behalf Of Travis Armbuster Sent: Monday, February 22, 2016 10:49 AM To: Phyllis Sanders Subject: Re: [Tessitura Memberships] Years of memberships
Hello Phyllis, I just slapped this together to give you an idea. I may work for you or might want to change the logic a bit. Run it SSMS and take a look. Again, just an example, but I hope it helps you.
Travis
select a.customer_no, c.description as memb_desc, a.memb_level, COUNT(distinct b.fyear)num_fyears, case when min(b.fyear)=MAX(b.fyear) then convert(varchar,min(b.fyear)) when min(b.fyear)<>MAX(b.fyear) then convert(varchar,min(b.fyear))+' - '+convert(varchar,MAX(b.fyear)) end as fyear_range from TX_CUST_MEMBERSHIP a join T_CAMPAIGN b on a.campaign_no = b.campaign_no join T_MEMB_LEVEL c on a.memb_level = c.memb_level group by a.customer_no,c.description,a.memb_level order by a.customer_no
From: Phyllis Sanders <bounce-phyllissanders8350@tessituranetwork.com> Sent: 2/22/2016 11:06:29 AM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Memberships Forum. You may reply to this message to post to the Memberships 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!