AO2011从后台数据库导出凭证表并标准化

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT --2****行
       cast (a.[会计年份] as varchar) + '-'+cast (a.[会计月份] as varchar) + '-'+cast (a.[凭证号] as varchar)+'#' as 凭证源号
      ,cast (a.[会计年份] as int) as 会计年份
      ,cast (a.[会计月份] as int) as 会计月份
      ,cast (a.[凭证号] as int) as 凭证号
      ,cast (a.[分录序号] as int) as 分录序号
      ,a.[科目编码]
      ,b.[科目全称]  --连接科目表，替换,a.[科目名称]
      ,a.[摘要]
      ,a.[借方金额]
      ,a.[贷方金额]
      --,a.[对方科目编码]
      --,a.[对方科目名称]
  into [挖矿公司].[dbo].[金蝶凭证库_标准表]
  FROM [AOC_Finance_****_000].[dbo].[凭证库] a 
          join [AOC_Finance_***_000].[dbo].[会计科目表] b
           on a.会计年份 = b.年度 and a.科目编码 = b.科目编码
  order by 2,3,4,5,6

select *
from [**公司].[dbo].[金蝶凭证库_标准表];