这是什么数据库的代码

[SambaGao]

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语法分析，提示：命令已成功完成。

[--小F--]

看起来是MSSQL的

[开着拖拉机泡妞]

[Quote=引用 4 楼 的回复:]

9494
[/Quote]