这是什么数据库的代码

2012-07-05 03:37:34 150 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

数据仓库中的代码整合与管控 LDM代码整合与管控 1>代码整合的概念 1.1>是一种编码代码的概念很容易让人搞混,这里的LDM代码不是指程序,而是一种编码(名词). 比如说身份证号,就是对个人ID的一个编码,不同的位数均代表不同的意义 4201062010XXXX 42:湖北省 01:武汉市 03:武昌区 2010:出生日期 1 阅读详情

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)

...全文