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
34,680 reads
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
34,680 reads
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.
2026-04-15 (first published: 2021-06-04)
2,698 reads
This article explains a way to use labels (last year, YTD, etc.) for report parameters.
2020-03-05
6,878 reads
2020-02-27
23,572 reads
Previous Monday to the Start of the Previous Quarter
2019-07-29 (first published: 2019-07-18)
537 reads
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)
5,223 reads
A function to add or subtract working days taking into account weekends and using a table of non-working days.
2019-05-01
980 reads
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)
720 reads
Both SQL Server and PostgreSQL are moving fast into AI territory — and if...
By Steve Jones
We keep adding new AI capabilities to Redgate Monitor, where it makes sense. Check...
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Comments posted to this topic are about the item Would You Retire Rather Than...
Comments posted to this topic are about the item Vector Search in SQL Server...
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers