SQL Query to create a Time Dimension at 15 mins granuality

You can start with

SELECT CAST(GETDATE() AS DATE) dt,

CONVERT(CHAR(5), DATEADD(MINUTE, 15 * Number, '19000101 00:00:00'), 108) [15min]

FROM master..spt_values

WHERE Type = 'p'

AND Number < 96

ORDER BY Number

---

Best Regards,Uri Dimant SQL Server MVP, http://ift.tt/1iQ9JkR



MS SQL optimization: MS SQL Development and Optimization

MS SQL Consulting: Large scale of database and data cleansing

Remote DBA Services: Improves MS SQL Database Performance

SQL Server Integration Services: Business Intelligence