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
439 reads
Simulate Rownumber (a la Oracle?)
Shows how to return data with a "rownumber". Some unique column is needed.
2002-04-05
341 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
432 reads
LastDayPreviousMonth / FirstDayCurrentMonth
The fastest way of getting LastDayPreviousMonth / FirstDayCurrentMonth
2002-04-04
185 reads
Blogs
Why I am running for the PASS Board in 2020
By HamishWatson
This blog post lists the reasons why I felt the need to run for...
Blog Refresh – Growing Readers
By gbargsley
Happy Tuesday everyone… In early 2017 I started blogging on this site in hopes...
Daily Coping 27 Oct 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
SSIS 2017 stopped running, not status is Pending Execution
We have 3 sql agent jobs that are running SSIS packages. Until this past...
cannot find MSOLEDBSQL driver for SSIS 2019 connection manager
In the list of connection manager driver, I cannot find MSOLEDBSQL, There is a...
Lean Coffee
Comments posted to this topic are about the item Lean Coffee
Ask SSC