select c.DESCR, c.CODE, 
       sum(case when s.ACCDTID = a.ID then s.SUM_ else  0  end) DT, 
       sum(case when s.ACCKTID = a.ID then s.SUM_ else  0  end) KT
  from      dbo._1SENTRY as s (NOLOCK)  /* Проводки */
       join (select ID, SCHKOD from dbo._1SACCS as a (NOLOCK) where SCHKOD like ' 62.%') a /* Счета */
		     on (s.ACCDTID = a.ID or s.ACCKTID = a.ID)       
       join dbo._1SJOURN as j (NOLOCK) on (s.DOCID = j.IDDOC), /* Журнал документов */
       dbo.SC133 as c (NOLOCK)         /* Контрагенты */
 where j.DATE_TIME_IDDOC >= '20090701' 
   and j.DATE_TIME_IDDOC <  '20091001' 
   and c.CODE = '11431' 
   and (c.ID = s.DTSC0 or c.ID = s.KTSC0)
group by c.DESCR, c.CODE

select  a.SCHKOD,  r.DATE
  from      dbo._1SBKTTL as r (NOLOCK)
       join (select ID, SCHKOD from dbo._1SACCS (NOLOCK) where SCHKOD like ' 62.%') as a on (r.ACCID = a.ID)            
 where r.DATE = (select max(w.DATE) 
                   from dbo._1SBKTTL as w (NOLOCK)
                  where  1 = 1 
                    --and w.DATE >= '20050101' 
                    and w.DATE < '20091001' 
                    and w.KIND =  1 
                    and w.ACCID = a.ID
                    and w.SC0 = '   E4T   ' )
   and r.KIND =  1     
   and r.SC0 = '   E4T   '

 62. 2.10. 	2009-07-01 00:00:00.000
 62. 1. 2. 	2009-07-01 00:00:00.000
 62. 2. 2. 	2009-07-01 00:00:00.000
 62. 2.15. 	2009-07-01 00:00:00.000
 62. 2. 4. 	2006-10-01 00:00:00.000
 62. 1. 4. 	2006-10-01 00:00:00.000
 62. 1.10. 	2009-01-01 00:00:00.000

select ACCDATE from _1ssystem