Day of Week
To find the day of week, regardless of-SET DATEFIRST -SET DATEFORMAT -SET LANGUAGEThe first one is based on Zellers Congruence.The second one is a SQL server proprietary.
2002-04-05
435 reads
Simulate Rownumber (a la Oracle?)
Shows how to return data with a "rownumber". Some unique column is needed.
2002-04-05
340 reads
Today with no time portion
How to get current day with the timeportion = 00:00:00.000.Works regardless of locale.
2002-04-05
429 reads
LastDayPreviousMonth / FirstDayCurrentMonth
The fastest way of getting LastDayPreviousMonth / FirstDayCurrentMonth
2002-04-04
183 reads
Blogs
Azure Cosmos DB: real-time data movement using Change Feed and Azure Functions
In this article, we will focus on creating a data pipeline to ETL (Extract,...
Quick 6 month check – how are those learning goals going…?
By HamishWatson
So in January I wrote a blog post on some goals I had this...
“An installation package for the product Microsoft SQL Server 2012 Native Client cannot be found” – during SQL Server 2017 install
By HamishWatson
This blog post is about a situation that initially perplexed me – I was...
Forums
Select n records in table X from a field on table Y
Hi, hope someone can help with this. I've the table gifts_to_give: Id_give number_of_gifts name ...
Select n records in table X from a field on table Y table
Hi, hope someone can help with this. I've the table gifts_to_give: Id_give number_of_gifts name ...
Error: 17892 Severity: 20 State: 1
Hi, I've been struggling for 5 days to solved this issue. We have a...
Ask SSC