帮我看一下哪里出错了？？？？？？？？？？

zjb_619 2009-03-20 04:09:00



sql="select a.con_pro_class,case(case(b.wc_num*100.0/(case when c.pc_num=0 or c.pc_num is null then 1 else c.pc_num end) as numeric(9,2)) as varchar)+'%' as e_cash1,"

     sql=sql & "case(case(d.wc_num*100.0/(case when e.pc_num=0 or e.pc_num is null then 1 else e.pc_num end) as numeric(9,2)) as varchar)+'%' as e_cash2,"

	 sql=sql & "case(case(f.wc_num*100.0/(case when g.pc_num=0 or g.pc_num is null then 1 else g.pc_num end) as numeric(9,2)) as varchar)+'%' as e_cash3,"

	 sql=sql & "case(case(h.wc_num*100.0/(case when i.pc_num=0 or i.pc_num is null then 1 else i.pc_num end) as numeric(9,2)) as varchar)+'%' as e_cash4,"

	 sql=sql & "case(case(j.wc_num*100.0/(case when k.pc_num=0 or k.pc_num is null then 1 else k.pc_num end) as numeric(9,2)) as varchar)+'%' as e_cash5,"

	 sql=sql & "case(case(l.wc_num*100.0/(case when m.pc_num=0 or m.pc_num is null then 1 else m.pc_num end) as numeric(9,2)) as varchar)+'%' as e_cash6,"

	 sql=sql & "case(case(n.wc_num*100.0/(case when o.pc_num=0 or o.pc_num is null then 1 else o.pc_num end) as numeric(9,2)) as varchar)+'%' as e_cash7,"

	 sql=sql & "case(case(p.wc_num*100.0/(case when q.pc_num=0 or q.pc_num is null then 1 else q.pc_num end) as numeric(9,2)) as varchar)+'%' as e_cash8,"

	 sql=sql & " from (select distinct con_pro_class from sale_tbl_contact) as a" 

	 sql=sql & " LEFT OUTER JOIN (select con_pro_class,sum(e_fin_num) as wc_num from sale_tbl_contact where (wc_date bwtween '"&date_1&"' and '"&date_2&"') and (wc_date between '"&date_1y&"-1-1' and '"&date_2y&"-1-31') group by con_tbl_class) as b on a.con_tbl_class=b.con_pro_class"

	 sql=sql & " LEFT OUTER JOIN (select con_pro_class,sum(e_num) as pc_num from sale_tbl_contact where (pc_date bwtween '"&date_1&"' and '"&date_2&"') and (pc_date between '"&date_1y&"-1-1' and '"&date_2y&"-1-31') group by con_tbl_class) as c on a.con_tbl_class=c.con_pro_class"

	 sql=sql & " LEFT OUTER JOIN (select con_pro_class,sum(e_fin_num) as wc_num from sale_tbl_contact where (wc_date bwtween '"&date_1&"' and '"&date_2&"') and (wc_date between '"&date_1y&"-2-1' and '"&date_2y&"-2-29') group by con_tbl_class) as d on a.con_tbl_class=d.con_pro_class"

	 sql=sql & " LEFT OUTER JOIN (select con_pro_class,sum(e_num) as pc_num from sale_tbl_contact where (pc_date bwtween '"&date_1&"' and '"&date_2&"') and (pc_date between '"&date_1y&"-2-1' and '"&date_2y&"-2-29') group by con_tbl_class) as e on a.con_tbl_class=e.con_pro_class"

	 sql=sql & " LEFT OUTER JOIN (select con_pro_class,sum(e_fin_num) as wc_num from sale_tbl_contact where (wc_date bwtween '"&date_1&"' and '"&date_2&"') and (wc_date between '"&date_1y&"-3-1' and '"&date_2y&"-3-31') group by con_tbl_class) as f on a.con_tbl_class=f.con_pro_class"

	 sql=sql & " LEFT OUTER JOIN (select con_pro_class,sum(e_num) as pc_num from sale_tbl_contact where (pc_date bwtween '"&date_1&"' and '"&date_2&"') and (pc_date between '"&date_1y&"-3-1' and '"&date_2y&"-3-31') group by con_tbl_class) as g on a.con_tbl_class=g.con_pro_class"

	 sql=sql & " LEFT OUTER JOIN (select con_pro_class,sum(e_fin_num) as wc_num from sale_tbl_contact where (wc_date bwtween '"&date_1&"' and '"&date_2&"') and (wc_date between '"&date_1y&"-4-1' and '"&date_2y&"-4-30') group by con_tbl_class) as h on a.con_tbl_class=h.con_pro_class"

	 sql=sql & " LEFT OUTER JOIN (select con_pro_class,sum(e_num) as pc_num from sale_tbl_contact where (pc_date bwtween '"&date_1&"' and '"&date_2&"') and (pc_date between '"&date_1y&"-4-1' and '"&date_2y&"-4-30') group by con_tbl_class) as i on a.con_tbl_class=i.con_pro_class"

	 sql=sql & " LEFT OUTER JOIN (select con_pro_class,sum(e_fin_num) as wc_num from sale_tbl_contact where (wc_date bwtween '"&date_1&"' and '"&date_2&"') and (wc_date between '"&date_1y&"-5-1' and '"&date_2y&"-5-31') group by con_tbl_class) as j on a.con_tbl_class=j.con_pro_class"

	 sql=sql & " LEFT OUTER JOIN (select con_pro_class,sum(e_num) as pc_num from sale_tbl_contact where (pc_date bwtween '"&date_1&"' and '"&date_2&"') and (pc_date between '"&date_1y&"-5-1' and '"&date_2y&"-5-31') group by con_tbl_class) as k on a.con_tbl_class=k.con_pro_class"

	 sql=sql & " LEFT OUTER JOIN (select con_pro_class,sum(e_fin_num) as wc_num from sale_tbl_contact where (wc_date bwtween '"&date_1&"' and '"&date_2&"') and (wc_date between '"&date_1y&"-6-1' and '"&date_2y&"-6-30') group by con_tbl_class) as l on a.con_tbl_class=l.con_pro_class"

	 sql=sql & " LEFT OUTER JOIN (select con_pro_class,sum(e_num) as pc_num from sale_tbl_contact where (pc_date bwtween '"&date_1&"' and '"&date_2&"') and (pc_date between '"&date_1y&"-6-1' and '"&date_2y&"-6-30') group by con_tbl_class) as m on a.con_tbl_class=m.con_pro_class"

	 sql=sql & " LEFT OUTER JOIN (select con_pro_class,sum(e_fin_num) as wc_num from sale_tbl_contact where (wc_date bwtween '"&date_1&"' and '"&date_2&"') and (wc_date between '"&date_1y&"-7-1' and '"&date_2y&"-7-31') group by con_tbl_class) as n on a.con_tbl_class=n.con_pro_class"

	 sql=sql & " LEFT OUTER JOIN (select con_pro_class,sum(e_num) as pc_num from sale_tbl_contact where (pc_date bwtween '"&date_1&"' and '"&date_2&"') and (pc_date between '"&date_1y&"-7-1' and '"&date_2y&"-7-31') group by con_tbl_class) as o on a.con_tbl_class=o.con_pro_class"

	 sql=sql & " LEFT OUTER JOIN (select con_pro_class,sum(e_fin_num) as wc_num from sale_tbl_contact where (wc_date bwtween '"&date_1&"' and '"&date_2&"') and (wc_date between '"&date_1y&"-8-1' and '"&date_2y&"-8-31') group by con_tbl_class) as p on a.con_tbl_class=p.con_pro_class"

	 sql=sql & " LEFT OUTER JOIN (select con_pro_class,sum(e_num) as pc_num from sale_tbl_contact where (pc_date bwtween '"&date_1&"' and '"&date_2&"') and (pc_date between '"&date_1y&"-8-1' and '"&date_2y&"-8-31') group by con_tbl_class) as q on a.con_tbl_class=q.con_pro_class"

	 sql=sql & " LEFT OUTER JOIN (select con_pro_class,sum(e_fin_num) as wc_num from sale_tbl_contact where (wc_date bwtween '"&date_1&"' and '"&date_2&"') and (wc_date between '"&date_1y&"-9-1' and '"&date_2y&"-9-30') group by con_tbl_class) as r on a.con_tbl_class=r.con_pro_class"

	 Set rs=Server.CreateObject("ADODB.RecordSet") 

      rs.Open sql,Conn,3,1