This script finds the first day of previous, current and next month as well as last day of previous, current and next month.The calculation is based on the ISO date format which makes it independant of the date format used on the SQL Server.The calculation is performed from a date - it can be altered […]
2004-12-02 (first published: 2004-10-21)
228 reads
By Steve Jones
ghough – n. a hollow place in your psyche that can never be filled;...
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
Hi, This is my table and data CREATE TABLE [dbo].[rpt_AR_StatementOfAcct_100]( [Id] [int] IDENTITY(1,1) NOT...
Hi All. I am seeing a scenario where SELECT is blocking a TRUNCATE statement...
Hi All, Need some help in tune a function which is reading TB's of...
Ask SSC