/*dialect*/create table TMPA5C5187B5E4711E48BA1E82AEAD as
select ROW_NUMBER() OVER(ORDER BY THEOL.FNAME asc ) FIDENTITYID ,THEOL.FNAME as EMPLOYEE,TBDTL.FFULLNAME as DEPARTMENT,APIN.FYEARLYSALARY as YEARLYSALARY,
SUM(ISNULL(AOE.FOVERTIMEDAYS,0)) as OVERTIMEDAYS,SUM(ISNULL(AOE.FLEAVEDAYS,0)) as LEAVEDAYS,
(APIN.FYEARLYSALARY + SUM(ISNULL(AOE.FOVERTIMEDAYS,0)) - SUM(ISNULL(AOE.FLEAVEDAYS,0))) as TOTALDAYS
from AVC_PersonalInformation APIN
left join (select a.FAPPLICANT,a.FAPPLICATIONDATE,SUM(a.FOVERTIMEDAYS) as FOVERTIMEDAYS,SUM(a.FLEAVEDAYS) as FLEAVEDAYS
from AVC_OverTime a inner join AVC_PersonalInformation b on a.FAPPLICANT=b.FEMPLOYEE
group by a.FAPPLICANT,a.FAPPLICATIONDATE)AOE on AOE.FAPPLICANT=APIN.FEMPLOYEE
left join T_HR_EMPINFO_L THEOL on APIN.FEMPLOYEE=THEOL.FID
left join T_BD_DEPARTMENT_L TBDTL on APIN.FDEPT=TBDTL.FDEPTID
where APIN.FEMPLOYEE =100046 and FDEPT=100014 and CONVERT(varchar(10),AOE.FAPPLICATIONDATE,120) >='2000-01-01' and CONVERT(varchar(10),AOE.FAPPLICATIONDATE,120) <= '2014-10-22'
group by THEOL.FNAME,TBDTL.FFULLNAME,APIN.FYEARLYSALARY
老是报错，说as附近有问题，create table TMPA5C5187B5E4711E48BA1E82AEAD as+ 查询条件这个oracle的写法，请问sqlserver写法怎么写？
推荐阅读