CREATE PROCEDURE zhixiao_acct.temp_proc1(leibie varchar(20),begin_date varchar(20),end_date varchar(20))
BEGIN
if leibie='电话' then
SELECT COUNT(*) FROM cc_data.ipg_tel where stdate>=begin_date and stdate<=end_date;
end if;
END
call zhixiao_acct.temp_proc1('电话','20180102','20180102')