Last Gift Amount and Max Gift Date

I believe it is in the output set cookbook. I would look there. If not I can post it up for you.

Travis

I believe it is in the output set cookbook. I would look there. If not I can post it up for you.

Travis

I've had a look in the Cookbook and they didn't seem quite what I was after. 

There is one that looks at last cont to a specific Campaign - I'll have a look at amending that, but I was sure someone would have done that already. Being a little lazy. 

Kelly

Here is a view that will get you going. If need more let me know.

USE [impresario]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create view [dbo].[lv_largest_gift]
as

/*****************************************************************************
created 5/17/2011 tla
select largest gift for output builder
select * from lv_largest_gift
******************************************************************************/

SELECT
customer_no,
max(cont_amt) as largest_cont_amt,
max(cont_dt) AS largest_cont_amt_dt

from t_contribution a

Where a.cont_amt =(select max(cont_amt) from t_contribution b where a.customer_no = b.customer_no)

GROUP BY a.customer_no


GO
grant select on [lv_largest_gift]  to impusers
GO

Thank you Travis!!