How to Find the Start and End Dates for the Current Week (and more)
Learn to calculate Start / First of Week, End of Week, Start of Next Week, Year, Quarter, and Month of the week, Week Numbers and more in T-SQL (Jeff Moden)
2022-07-13
15,398 reads
Calendar Table
Create Calendar Table Using Power Query M Language
Learn how to create a customizable calendar date table that can be used for Power BI reports using Power Query.
2021-03-03
Time Slots - An Essential Extension to Calendar Tables
After answering many forum entries from developers asking for help with dealing with SQL that involved time intervals and ranges, Dwain dreamed of a generalized tool that sets up time slots of various sorts without the need to experiment; that could do the heavy lifting, so that developers could do aggregations and reports based on time intervals without the hard graft. Here is Dwain's dream made reality.
2015-05-05
7,291 reads
Blogs
SQL Saturday Denver 2023–VCS Primer for the Database slides
By Steve Jones
My slides are here: VCS Primer Denver 2023 This was an overview of what...
Future Data Driven 2023 is This Week
By Steve Jones
The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...
Opening the SQL Prompt Command Palette
By Steve Jones
A few years ago SQL Prompt added a command palette to let you search...
Forums
Never miss 35% discount science teacher shirts at Teachersgram
As autumn paints the world with vibrant hues and cool breezes signal the arrival...
köp Nembutal/Pentobarbital utan recept alo2innf@duck.com beställ Nembutal från
Förstå Nembutal eller Pentobarbital Nembutal, även känd som pentobarbital, är ett...
Kamagra jelly - Get Erection For Penetration
PDE5 inhibitor medications include the impotence treatment cenforce 130mg - Get Erection for Penetration....
Ask SSC