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
11,170 reads
datediff
Implementing Date Calculations in SQL
This article explains a way to use labels (last year, YTD, etc.) for report parameters.
2020-03-05
6,341 reads
2020-02-27
20,745 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)
451 reads
Blogs
Create and Verify Microsoft Fabric Capacity
From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal....
What is Always Encrypted and how does it work?
Always Encrypted was a new encryption feature added to SQL Server with the 2016...
Power BI – Empowering Users to Disable Tooltips
By DataOnWheels
Let’s set the scene. You’ve built a wonderful, useful, and descriptive report for your...
Forums
how to determine if we can delete the index can be removed
In SQL Server database, there is a table InventDim with two indexes: Idx1 with...
how to determine if we can delete the index can be removed
In SQL Server database, there is a table InventDim with two indexes: Idx1 with...
how to determine if we can delete the index can be removed
The table InventDim has some indexes, we create one index idx1 which has index...
Ask SSC