报表(其它账套)引入
kingdee吧
全部回复
仅看楼主
level 12
yazhaierze 楼主
delete From t_rpt_propitem
delete From T_Rpt_Content
INSERT INTO [AIS20110921204104].[dbo].[t_Rpt_PropItem]([FPropClsID], [FPropItemID], [FNumber], [FName], [FName_Cht], [FName_EN])
select [FPropClsID], [FPropItemID], [FNumber], [FName], [FName_Cht],
[FName_EN] from AIS20110920133119..t_rpt_propitem
INSERT INTO [AIS20110921204104].[dbo].[t_Rpt_Content]([FRptID], [FRptName], [FSysName], [FYear], [FPeriod], [FOwner], [FRptType], [FRptData], [FPrinterBuf], [FLastOperator], [FLastDate], [F1001], [FRptName_Cht], [FRptName_EN], [F1002], [F1003])
select [FRptID], [FRptName], [FSysName], [FYear], [FPeriod], [FOwner], [FRptType], [FRptData], [FPrinterBuf], [FLastOperator], [FLastDate], [F1001], [FRptName_Cht], [FRptName_EN], [F1002], [F1003]
from AIS20110920133119..t_rpt_content

2011年10月24日 10点10分 1
1