Implementing Date Calculations in SQL
This article explains a way to use labels (last year, YTD, etc.) for report parameters.
2020-03-05
5,130 reads
datediff
2020-02-27
13,433 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)
404 reads
Blogs
Server Review Essentials for Accidental and Junior DBAs—Setting Up (Part 1)
By Kevin3NF
Welcome to a new year, and a new look at what I’ve learned in...
Azure SQL vCore vs DTU
By Arun Sirpal
If you are building database solutions in Azure , using Azure SQL Database then...
Synapse Analytics Spark Example 2 - ROW_NUMBER()
By Ed Elliott
The next example is how to do a ROW_NUMBER(), my favourite window function. T-SQL SELECT...
Forums
XML Vs Non-XML
I am using SQL Server 2008 R2. While using XML data type and XQuery...
Staging or UAT Environment
Hi Experts, Currently, we are using the enterprise edition of SQL Server 2014 in...
Transaction was deadlocked on lock resources with another process
I have table in SQL Server 2014. Please find the structure below: CREATE TABLE...
Ask SSC