SQL Server – Generate and Use Time / Duration Dimension

This blog post shows how I created, generated data for and used a "Duration" dimension with SQL Server and PowerBI

Advertisements

Oracle Tip – Generate “N” rows of dates or numbers serially

Sometimes, you would have a situation where you need to generate a table with N number of rows that you can use as the basis to join and restrict other tables. For example, to get the 100 dates starting from a certain date as rows, a typical technique is to select ROWNUM from all_objects to … Continue reading Oracle Tip – Generate “N” rows of dates or numbers serially