날짜의 경우는

몇년치..또는 몇십년치를 그냥 Table 에 쌓아두시구..

그걸 토대로 하시면 될겁니다.

나중에도 요긴하게 쓰이실 거에요~~

하기 쿼리문에서 With절의

table3 이 그 역할이라고 보시면 될듯..

/* --------------- 쿼리 시작 ----------------------- */

Declare @as_from_idx  char(10)
Declare @as_to_idx    char(10)
Declare @as_from_ymd  char(10)
Declare @as_to_ymd    char(10)

Select @as_from_idx = '1'
Select @as_to_idx   = '3'
Select @as_from_ymd = '20150101'
Select @as_to_ymd   = '20150103'

With table1 As
(
Select '3' As idx,'aaa' As id,1000 As 금액,'20150101' As 날짜 Union All
Select '2' As idx,'aab' As id,1000 As 금액,'20150101' As 날짜 Union All
Select '1' As idx,'aab' As id,1000 As 금액,'20150102' As 날짜
)
,table2 As
(
Select '3' As idx,'aaa' As id,100  As 금액,'20150101' As 날짜 Union All
Select '2' As idx,'aab' As id,2000 As 금액,'20150101' As 날짜 Union All
Select '1' As idx,'aab' As id,100  As 금액,'20150102' As 날짜
)
,table3 As
(
Select '20150101' As 날짜 Union All
Select '20150102' As 날짜 Union All
Select '20150103' As 날짜 Union All
Select '20150104' As 날짜
)
       Select
              a.날짜        As 날짜
--             ,a.idx         As idx
             ,Sum(a.금액1)  As 금액1
             ,Sum(a.금액2)  As 금액2
             ,  IsNull(Sum(a.금액1),0)
              - IsNull(Sum(a.금액2),0)
                            As 차액
         From (
                   Select
                          a.날짜 As 날짜
                         ,a.금액 As 금액1
                         ,0      As 금액2
                     From table1 As a
                    Where a.idx  Between @as_from_idx And @as_to_idx
                      And a.날짜 Between @as_from_ymd And @as_to_ymd
              
                Union All
               
                   Select
                          a.날짜 As 날짜
                         ,0      As 금액1
                         ,a.금액 As 금액2
                     From table2 As a
                    Where a.idx  Between @as_from_idx And @as_to_idx
                      And a.날짜 Between @as_from_ymd And @as_to_ymd

                Union All
               
                   Select
                          a.날짜 As 날짜
                         ,0      As 금액1
                         ,0      As 금액2
                     From table3 a
                    Where a.날짜 Between @as_from_ymd And @as_to_ymd
                      And Not Exists (
                                        Select 'x'
                                          From table1 x                                         
                                         Where x.날짜 Between @as_from_ymd And @as_to_ymd
                                           And x.idx Between @as_from_idx And @as_to_idx
                                           And x.날짜 = a.날짜
                                     )
                      And Not Exists (
                                        Select 'x'
                                          From table2 x                                         
                                         Where x.날짜 Between @as_from_ymd And @as_to_ymd
                                           And x.idx Between @as_from_idx And @as_to_idx
                                           And x.날짜 = a.날짜
                                     )

              ) a
     Group By
              a.날짜
--             ,a.idx
     Order By
              a.날짜            
--             ,a.idx

/* --------------- 쿼리 끝 ----------------------- */

--결과물

날짜          | 금액1 |  금액2 |  차액 |

-------------------------------------------

20150101  | 2000   |  2100   |  -100  |
20150102  | 1000   |  100     |  900   |
20150103  | 0         |  0         |  0       |