鍗囩駭鍒?.2.3鍚庯紝鏂板彂OA鐢熸垚涓嶄簡鎵嬫満鍥劇墖銆?/span>
鎺掗櫎鏂規(guī)硶錛?/span>
1銆佸湪甯愬搴撴墽琛屼笅鍒楄鍙?/p>
Select * from sdpo020b
2銆佹煡鐪嬩笅 瀛楁 鈥減o020b26鈥濆瓧孌電殑鎺掑垪欏哄簭錛屽鏋滀笉鏄湪 po020b25鍜宲o020b27涔嬮棿錛?br/>
鍒欒鏄庢湁闂錛岄渶鎵ц鑴氭湰錛氣€渟dpo020b.txt鈥?鏂囦歡瑙侀檮浠?
3銆佽嫢瀹㈡埛宸茬粡鍙戜簡OA錛屼笉鎯抽噸鏂板彂璧鳳紝鍒欓渶鍦ㄥ笎濂楀簱鎵ц涓嬪垪鑴氭湰錛堣繖涓鏁版嵁閲忓ぇ灝忥紝鎵ц鏃墮棿鐩稿簲鍔犻暱錛夛細
Declare @po00402 varchar(40),
@po00403 varchar(40),
@po00418 varchar(40)
Declare sdpo004_cur Cursor For
Select po00402,po00403,po00418 From sdpo004_AllRecord Where Not Exists(
Select 1 From sdpo100 Where po10011=po00418) And Not Exists(
Select 1 From sdcf011 Where cf01105=po00418) And Not Exists(
Select 1 From sdcf027 Where cf02707=po00418) order by po00402
Open sdpo004_cur
Fetch Next From sdpo004_cur Into @po00402,@po00403,@po00418
While @@Fetch_Status<>-1
Begin
Exec InsertToImage @po00402, @po00403, @po00418
Fetch Next From sdpo004_cur Into @po00402,@po00403,@po00418
End
Close sdpo004_cur
Deallocate sdpo004_cur