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
17,882 reads
DATEADD
Stairway to DAX and Power BI - Level 17: Time Intelligence Functions: The DAX DATEADD() Function
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX DATEADD() function, discussing its syntax, uses and operation. He then provides hands-on exposure to DATEADD(), focusing largely upon a popular use in creating prior-period values at multiple Date hierarchy levels.
2023-08-19 (first published: 2021-06-04)
2,126 reads
Implementing Date Calculations in SQL
This article explains a way to use labels (last year, YTD, etc.) for report parameters.
2020-03-05
6,503 reads
2020-02-27
21,738 reads
Previous Monday to the Start of the Previous Quarter
Previous Monday to the Start of the Previous Quarter
2019-07-29 (first published: 2019-07-18)
457 reads
Add working days but avoid holidays
A function to add or subtract working days taking into account weekends and using a table of non-working days.
2019-07-10 (first published: 2019-06-26)
4,683 reads
Add working days but avoid holidays
A function to add or subtract working days taking into account weekends and using a table of non-working days.
2019-05-01
922 reads
Add working days but avoid holidays
A function to add or subtract working days taking into account weekends and using a table of non-working days.
2019-04-25 (first published: 2019-04-18)
692 reads
Blogs
Friday Flyway Tips–Comparison Options
By Steve Jones
Recently a customer asked how they could get index changes to be captured in...
A New Word: Guiltwrights
By Steve Jones
giltwrights – n. the imaginary committee of elders that keeps a running log of...
Becoming Kristyna Ferris <3
By DataOnWheels
Hey folks, fun personal post today. A few weeks ago, I got married! My...
Forums
Compare all tables row counts for 2 server instances?
USE [DBName] SELECT QUOTENAME(SCHEMA_NAME(sOBJ.schema_id)) + '.' + QUOTENAME(sOBJ.name) AS [TableName] , SUM(sPTN.Rows) AS [RowCount]...
Backing Up Master
Comments posted to this topic are about the item Backing Up Master
Window Function Basics - PARTITION BY
Comments posted to this topic are about the item Window Function Basics - PARTITION...
Ask SSC