Hi!I'm pulling together info for a deep dive on our members and donors and a few data points have been elusive, especially Largest Gift. I cruised the forums and nothing really fit. I made something that kind of works but it doesn't consider soft credits on the record. I'm currently without access to SQL, so that isn't an avenue for this at this time either.
(SELECT A.* FROM dbo.VS_ELEMENTS_CONTRIBUTION A INNER JOIN (SELECT customer_no, ref_no, RANK() OVER (PARTITION BY customer_no ORDER BY cont_amt DESC, cont_dt DESC, create_dt DESC, ref_no DESC) AS ranking FROM dbo.VS_CONTRIBUTION_WITH_INITIATOR) B ON A.customer_no = B.customer_no AND A.ref_no = B.ref_no AND B.ranking = 1)
Like I said, it works fine, but not with soft credits which is a real bummer.
Can someone give me a nudge in the right direction?
Jenny
Soft credits have been a sore spot on Tess since forever (I can only guess the Met didn't/doesn't use them).
You don't have access to SSMS, but does anyone at your org? I.e., if I sent a view over, could someone install it? We use SCs all the time, I have views that include them.
Chris, I would be mighty interested in those if you don't mind sharing?.... Soft credits are a pain in my you-know-what.
Please drop me a line at chrisj@guthrietheater.org, and I'll connect you. :-)
I would love that if you are willing to share.
Thank you, Chris! That would be really helpful, in a big way. joneill-englund@smm.org