Ë­¿ÉÒÔ°ÑÕâ¸ösql serverµÄspת»»Îªmysql£¬¸ßÊÖÏÔÄÜ£¡

create procedure sp_BG20090916
@datamain datetime
as
/***************ÕûºÏflow_run_dataºÍflow_run±íµ½Ö¸¶¨ÈÕÆÚµÄÁÙʱ±íÖÐ*****************/
if object_id('table_davy1') is not null                --¹¹Ôìtable_davy1±íµÄ½á¹¹
drop table table_davy1
create table table_davy1(run_id int,item_id int, item_data varchar(500))
insert into table_davy1
select t1.*
from table_oa3 t1,table_oa2 t2
where t1.run_id=t2.run_id
and  t2.flow_id=13
and  datepart(yy,t2.begin_time)=datepart(yy,@datamain)
and  datepart(mm,t2.begin_time)=datepart(mm,@datamain)
--and  convert(varchar(10),t2.begin_time,120)=convert(varchar(10),@datamain,120)
/********************ͨ¹ýÓαêµÄʹÓý«ÐÐÁнøÐÐת»»*********************/
declare  cursor_t1  cursor for  select distinct run_id from table_davy1
declare @id int
declare @name varchar(30) --ÉêÇëÈË
declare @data varchar(30)--ÉêÇëÈÕÆÚ
declare @depart varchar(30) --ÉêÇ벿ÃÅ
declare @dpt_person varchar(30)--²¿ÃŸºÔðÈË
declare @things varchar(500) --ÉêÁìÎïÆ·
declare @note varchar(500)  --ÉêÁì˵Ã÷
declare @result varchar(500)--ÉóÅú½á¹û
declare @advice varchar(500) --ÉóÅúÒâ¼û
if object_id('table_oa') is not null                --¹¹Ôìtable_oa±íµÄ½á¹¹
drop