delete from FactSales
insert into dbo.FactSales(TimeKey)
select DATEPART(hour, date_sales)*60*60
+ DATEPART(minute, date_sales)*60
+ DATEPART(second, date_sales) as TimeKey
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
Igor is a business intelligence consultant working in Tampa, Florida. He has a BS in Finance from University of South Carolina and Masters in Information Management System from University of South Florida. He also has following professional certifications: MCSD, MCDBA, MCAD.