【已解决】转换给sql语句问题

我写的KSQL语句，转换成ORACLE没报错，转换成SQL就报错了，不知道KSQL语句哪里写错了，求指教。SQL报错的信息为：
format sql error. target database is 'MS SQL Server' detail message is :
ERROR
source sql is :

原Ksql语句如下：
select ROW_NUMBER() OVER(ORDER BY TOOSL.fname asc ) FIDENTITYID ,
TOOSL.fname as SALESORGANIZATION,
TBAYL.fdatavalue as ASSISTANTDATAENTRY,
TBDTL.ffullname as SALESDEPARTMENT,
VBSNL.FNAME as SALESMAN,
TBCPL.fname as CUSTOMERAREA,
TBCRL.fname as CUSTOMER,
TBMPL.fname as MATERIALGROUP,
TBMLL.fname as MATERIALNAME,
sum(ISNULL(A.FREALQTY, 0)) - sum(ISNULL(A.FReturnQty, 0)) as SALESNUMBER,
sum(ISNULL(A.OUTAMOUNT, 0)) - sum(ISNULL(A.RETURNAMOUNT, 0)) as SALESINCOME,
sum(ISNULL(A.OUTCOSTS, 0)) - sum(ISNULL(A.RETURNCOSTS, 0)) as SALESCOSTS,
(sum(ISNULL(A.OUTAMOUNT, 0)) - sum(ISNULL(A.RETURNAMOUNT, 0))) -
(sum(ISNULL(A.OUTCOSTS, 0)) - sum(ISNULL(A.RETURNCOSTS, 0))) as salesgrossprofit,
round((case
when (sum(ISNULL(A.OUTAMOUNT, 0.00)) -
sum(ISNULL(A.RETURNAMOUNT, 0.00))) = 0 then
0.0
else
((sum(ISNULL(A.OUTAMOUNT, 0.00)) -
sum(ISNULL(A.RETURNAMOUNT, 0.00))) -
(sum(ISNULL(A.OUTCOSTS, 0.00)) - sum(ISNULL(A.RETURNCOSTS, 0.00)))) /
(sum(ISNULL(A.OUTAMOUNT, 0.00)) -
sum(ISNULL(A.RETURNAMOUNT, 0.00)))
end),
3) as salesrate,
ISNULL(A.FAssAmount, 0) as referencecost,
(sum(ISNULL(A.OUTAMOUNT, 0)) - sum(ISNULL(A.RETURNAMOUNT, 0)) -
ISNULL(A.FAssAmount, 0)) as referenceprofit
into TMP8A00C5FB81B311E4A2BAE82AEAD
from (select TSOK.fsaleorgid,
TSOK.fchatype,
TSOK.fsaledeptid,
TSOK.fsalesmanid,
TSOK.fcustomerid,
TSOY.fmaterialid,
TSOY.FREALQTY as FREALQTY,
0 as FReturnQty,
TSOYF.OUTAMOUNT as OUTAMOUNT,
0 as RETURNAMOUNT,
TSOYC.OUTCOSTS as OUTCOSTS,
0 as RETURNCOSTS,
TSOY.Fassamount
from T_SAL_OUTSTOCKENTRY TSOY
inner join T_SAL_OUTSTOCK TSOK
on TSOY.FID = TSOK.FID
inner join T_Bd_Material TBML
on TBML.fmaterialid = TSOY.fmaterialid
left join (select A.fentryid, sum(FAmount_LC) as OUTAMOUNT
from T_SAL_OUTSTOCKENTRY_F A
inner join T_SAL_OUTSTOCKENTRY B
on A.fentryid = B.fentryid
group by A.fentryid) TSOYF
on TSOY.fentryid = TSOYF.fentryid
left join (select A.fentryid, sum(FAmount_LC) as OUTCOSTS
from T_SAL_OUTSTOCKENTRY_C A
inner join T_SAL_OUTSTOCKENTRY B
on A.fentryid = B.fentryid
inner join T_HS_CALDIMENSIONS C
on A.fdimensionid = C.fdimensionid
where C.facctsystemid = 1
and C.FFINORGID in (1,100001,100002,100003,104001,101211,101212,101218,101219,102136,103001)
and C.FACCTPOLICYID = 1
group by A.fentryid) TSOYC
on TSOY.fentryid = TSOYC.fentryid
where TSOK.FSALEORGID in (1,100001,100002,100003,104001,101211,101212,101218,101219,102136,103001)
and CONVERT(varchar(10),TSOK.Fdate,120) >= '2013-12-01'
and CONVERT(varchar(10),TSOK.Fdate,120) <= '2014-12-12'
union all
select TSRK.fsaleorgid,
TSRK.fchatype,
TSRK.fsaledeptid,
TSRK.fsalesmanid,
TSRK.FRETCUSTID,
TSRY.fmaterialid,
0 as FREALQTY,
TSRY.FREALQTY as FReturnQty,
0 as OUTAMOUNT,
TSRYF.RETURNAMOUNT as RETURNAMOUNT,
0 as OUTCOSTS,
TSRYC.RETURNCOSTS as RETURNCOSTS,
TSRY.Fassamount
from T_SAL_RETURNSTOCKENTRY TSRY
inner join T_SAL_RETURNSTOCK TSRK
on TSRY.FID = TSRK.FID
inner join T_Bd_Material TBML
on TBML.fmaterialid = TSRY.fmaterialid
left join (select A.fentryid, sum(FAmount_LC) as RETURNAMOUNT
from T_SAL_RETURNSTOCKENTRY_F A
inner join T_SAL_RETURNSTOCKENTRY B
on A.fentryid = B.fentryid
group by A.fentryid) TSRYF
on TSRY.Fentryid = TSRYF.fentryid
left join (select A.Fentryid, sum(FAmount_LC) as RETURNCOSTS
from T_SAL_RETURNSTOCKENTRY_C A
inner join T_SAL_RETURNSTOCKENTRY B
on A.fentryid = B.fentryid
inner join T_HS_CALDIMENSIONS C
on A.fdimensionid = C.fdimensionid
where C.facctsystemid = 1
and C.FFINORGID in (1,100001,100002,100003,104001,101211,101212,101218,101219,102136,103001)
and C.FACCTPOLICYID = 1
group by A.Fentryid) TSRYC
on TSRY.Fentryid = TSRYC.Fentryid
where TSRK.FSALEORGID in (1,100001,100002,100003,104001,101211,101212,101218,101219,102136,103001)
and CONVERT(varchar(10),TSRK.Fdate,120) >= '2013-12-01'
and CONVERT(varchar(10),TSRK.Fdate,120) <= '2014-12-12' ) A
inner join T_Bd_Material TBML
On A.fmaterialid = TBML.fmaterialid
inner join T_BD_MATERIAL_L TBMLL
on A.FMATERIALID = TBMLL.FMATERIALID
inner join t_Bd_Materialgroup_l TBMPL
on TBML.fmaterialgroup = TBMPL.fid
left join T_BD_CUSTOMER TBCR
on A.fcustomerid = TBCR.fcustid
left join T_BD_CUSTOMER_L TBCRL
on TBCR.fcustid = TBCRL.fcustid
left join T_BD_CUSTOMERGROUP_L TBCPL
on TBCR.Fprimarygroup = TBCPL.fid
left join V_BD_SALESMAN_L VBSNL
on A.fsalesmanid = VBSNL.FID
left join T_BD_DEPARTMENT_L TBDTL
on A.fsaledeptid = TBDTL.fdeptid
left join T_ORG_ORGANIZATIONS_L TOOSL
on A.fsaleorgid = TOOSL.forgid
left join t_bas_assistantdataentry_l TBAYL
on A.fchatype = TBAYL.fentryid
group by TOOSL.fname,
TBAYL.fdatavalue,
TBDTL.ffullname,
VBSNL.FNAME,
TBCPL.fname,
TBCRL.fname,
TBMPL.fname,
TBMLL.fname,
A.FAssAmount