On 12/29/18 12:34 PM, Glenn Schultz wrote:
> All,
> Following my earlier post on variable instantiation, I rethought how I was working with dates and realized I can fix
thedate and use static interval. I came up with this recursive CTE which is the end goal. However, the problem is
thatthe convexity query cannot be used as a subquery. So I think I need to use a join of convexity on the original
query- not sure I am little stuck at this point but I feel I am close. Any help would be appreciated.
>
> -Glenn
If you are trying to find month summaries, then maybe date_trunc would be easier:
select date_trunc('month', fctrdt),
round(smmtocpr(cast(sum(currrpb * case when fnmloan.fctrdt = fnmloan_data.fctrdt then fnmloan_data.event else 0
end)/sum(currrpb) as numeric) * 100),4) * 100 as "CPR 3mo"
from fnmloan
group by date_trunc('month', fctrdt)