Home Forums SQL Server 2008 T-SQL (SS2K8) Union difficulty RE: Union difficulty
Chris Wooding
SSCarpal Tunnel
Points: 4530
More actions
April 16, 2014 at 8:16 am
#1706485
I think you need to modify the Group By clause in the first select to
group by ath_stlmnt_instr_id, ath_instr_id, ae.stlmnt_line_instr_id, ath_gl_num, ath_cost_cntr
but you should also review the way you're handling the ath_usdamt calculation.