#DateForumTypeThreadPost
117 Mar 2016 @ 10:50 PDTDatabaseReplyHelp with SQL for reporting month totals SEL MEMBER,ELIG_DT,SEQ FROM  (  SEL MEMBER,ELIG_DT, EXTRACT( MONTH FROM ELIG_DT ) MN, ROW_NUMBER () OVER ( PARTITION BY MEMBER ORDER BY ELIG_DT  ) RN , ( CASE WHEN MN <>...