SQLÓï¾äдÈëdelphiµÄadoquery.sql.addÖÐ

ÈçÌ⣬ÎÒÏë°ÑÏÂÃæÕâ¶ÎsqlÓï¾äдÔÚadoqueryÖУ¬µ«ÊÇ×ÜÊÇ´¦Àí²»ºÃµ¥ÒýºÅµÄÎÊÌâ


select b.Ô­²ÄÁÏÃû³Æ,a.²ÄÁϺÅ,ʱ¼ä,Èë¿âÊýÁ¿ = sum(Èë¿âÊýÁ¿),³ö¿âÊýÁ¿ = sum(³ö¿âÊýÁ¿)
from
(
select '²ÄÁϺÅ' = case when isnull(Ô­ÁÏÈë¿â±í.²ÄÁϺÅ,'') = '' then Ô­Áϳö¿â±í.²ÄÁϺŠelse Ô­ÁÏÈë¿â±í.²ÄÁϺŠend,
      'ʱ¼ä' = case when isnull(Ô­ÁÏÈë¿â±í.Èë¿âʱ¼ä,'') = '' then convert(char(10),Ô­Áϳö¿â±í.³ö¿âʱ¼ä,120)
                        else convert(char(10),Ô­ÁÏÈë¿â±í.Èë¿âʱ¼ä,120) end,
      'Èë¿âÊýÁ¿' = isnull(Èë¿âÊýÁ¿,0),
      '³ö¿âÊýÁ¿' = isnull(³ö¿âÊýÁ¿,0)
from Ô­ÁÏÈë¿â±í full outer join Ô­Áϳö¿â±í
on Ô­ÁÏÈë¿â±í.²ÄÁϺŠ= Ô­Áϳö¿â±í.²ÄÁϺÅ
  and convert(char(10),Èë¿âʱ¼ä,120) = convert(char(10),³ö¿âʱ¼ä,120)
  and Ô­ÁÏÈë¿â±í.²Ö¿âºÅ = Ô­Áϳö¿â±í.²Ö¿âºÅ
) a,Ô­²ÄÁÏÐÅÏ¢±í b
where ʱ¼ä is not null
and b.²ÄÁϺÅ=a.²ÄÁϺÅ
and ʱ¼ä>='2010-01-23'
and ʱ¼ä <='2010-01-24'
group by Ô­²ÄÁÏÃû³Æ,ʱ¼ä,a.²ÄÁϺÅ
order by ʱ¼ä,a.²ÄÁϺÅ


and ʱ¼ä>='2010-01-23'
and ʱ¼ä <='2010-01-24'Õâ¶ÎÎÒ»¹ÏëÓÃ

and ʱ¼ä>=datetimePicker1.datetime
and ʱ¼ä <=datetimePicker2.datetime À´´úÌæ

---

¿´Á¬½