Reply to thread

Message: <blockquote data-quote="twisted" data-source="post: 18236471" data-attributes="member: 82108">SELECT EMP_NUMBER AS EMP_NUMBER,trn_processed_year AS MON_PRS_YEAR,trn_processed_month AS MON_PRS_MONTH,SUM(trn_processed_amt) TXP_PROC_CUR_BASE_EMP_AMT    FROM hs_pr_processedflattxn a,hs_pr_profile f  where TRN_DTL_CODE in ('FE0005')and COALESCE(trn_processed_amt,0) > 0  and (trn_processed_year = YEAR(TAX_FROM) AND trn_processed_month >=  MONTH(TAX_FROM)) group by emp_number,trn_processed_year,trn_processed_month</blockquote>

Top Bottom