예전에 도움을 주셔서 다른 보기 좋게 장부가 만들어 지고 있습니다..그런데 한가지 도저히 해결 안되는 부분이 있습니다

월계 와 누계를  월 단위로 표시 하고자 하는데...도저히 제 머리로는..안되어서 이렇게 질문 드립니다.

Create table #res
  (
    name_code char(4) null ,
    inout_day char(8) null  ,
    slip_no char(4) null ,
    n_remark char(30) null ,
    dr_amt float ,
    cr_amt float ,

    n_id char(1) )

insert into #res

select name_code, '' INOUT_DAY, '' SLIP_NO , '<전기이월>',
        ( SELECT  CASE WHEN SUM(DR_AMT) IS NULL THEN 0 ELSE SUM(DR_AMT) END
          FROM TBL_SUNTOT AS A1
          WHERE A1.INOUT_DAY >='20140000'
               AND A1.INOUT_DAY <'20140101'
               AND A1.COM_ID='S'
               AND A1.COMP_ID='S03'
               AND A1.ACC_ID='259'
               AND A1.NAME_CODE='1022' ) -
         (SELECT  CASE WHEN SUM(CR_AMT) IS NULL THEN 0 ELSE SUM(CR_AMT) END
           FROM TBL_SUNTOT AS A2
           WHERE A2.INOUT_DAY >='20140000'
               AND A2.INOUT_DAY <'20140101'
               AND A2.COM_ID='S'
               AND A2.COMP_ID='S03'
               AND A2.ACC_ID='259'
               AND A2.NAME_CODE='1022'  ) AS DR_AMT, 0 CR_AMT, 0 n_id
 
from tbl_suntot A
WHERE A.com_id='S'
     and A.comp_id='S03'
     and A.acc_id='259'
     and A.name_code='1022'
    
group by A.name_code

UNION

select name_code, inout_day, slip_no, n_remark, dr_amt, cr_amt, 1 n_id
from tbl_suninout
where inout_day >='20140101'
    and inout_day <='20141231'
    and com_id='S'
    and comp_id='S03'
    and acc_id='259'
    and name_code='1022'

UNION
select name_code, substring(inout_day, 1,6)as inout_day, '','월계',
( SELECT  CASE WHEN SUM(DR_AMT) IS NULL THEN 0 ELSE SUM(DR_AMT) END
          FROM TBL_SUNTOT AS A1
          WHERE A1.INOUT_DAY >='20140101'
               AND A1.INOUT_DAY <='20141231'
               AND A1.COM_ID='S'
               AND A1.COMP_ID='S03'
               AND A1.ACC_ID='259'
               AND A1.NAME_CODE='1022'  ) as dr_amt,
         (SELECT  CASE WHEN SUM(CR_AMT) IS NULL THEN 0 ELSE SUM(CR_AMT) END
           FROM TBL_SUNTOT AS A2
           WHERE A2.INOUT_DAY >='20140101'
               AND A2.INOUT_DAY <='20141231'
               AND A2.COM_ID='S'
               AND A2.COMP_ID='S03'
               AND A2.ACC_ID='259'
               AND A2.NAME_CODE='1022'  ) as cr_amt, 2 n_id
       
from tbl_suntot
where com_id='S'
   and  com_id='S'
  and   comp_id='S03'
   and  acc_id='259'
   and  name_code='1022'

group by name_code, inout_day

select * from #res

order by n_id

 이렇게 작성 하여 query를 돌리면  월단위로 구분 되어지지 않습니다.  월단위로 구분 되어 월계가 표시 되려면 어찌 해야 하는지요!