当前位置: 代码迷 >> Sql Server >> 这是什么数据库的代码,该如何处理
  详细解决方案

这是什么数据库的代码,该如何处理

热度:86   发布时间:2016-04-27 12:01:02.0
这是什么数据库的代码
select c.ExternalID as AccountExternalID, 
cast(c.ExternalID as varchar(10)) + Cast(YEAR(f.InvoiceDate) as varchar(4)) + Cast(MONTH(f.InvoiceDate) as varchar(2)) as ExternalID, 
Cast(MONTH(f.InvoiceDate) as varchar(2)) + '/1/' + Cast(YEAR(f.InvoiceDate) as varchar(4)) as SalesDate, 
YEAR(f.InvoiceDate) as SalesYear, MONTH(f.InvoiceDate) as SalesMonth, SUM(f.ExtSales) as Sales, SUM(f.GrossMargin) as GrossMargin
from Flash f
join SFDCAccountIDs c on f.CustID = c.CustID
where YEAR(f.InvoiceDate) = YEAR(getdate())
and c.ExternalID is not null
Group by c.ExternalID, YEAR(f.InvoiceDate), MONTH(f.InvoiceDate)
Order by c.ExternalID, YEAR(f.InvoiceDate), MONTH(f.InvoiceDate)

------解决方案--------------------
SQL Server的
------解决方案--------------------
经SQL SERVER 2005语法分析,提示:命令已成功完成。
------解决方案--------------------
看起来是MSSQL的
  相关解决方案