How to Handle Calculations Related to fiscal year and quarter
This article describes an easy way to handle calculation based on fiscal year and quarter
2014-07-28
13,237 reads
Raymond Xie
Find dependencies between field and sp/function
This script shows the stored procedures and functions affected by field name change in a table.
2014-04-09 (first published: 2014-03-18)
955 reads
2013-07-10 (first published: 2013-06-19)
1,583 reads
Blogs
Daily Coping 3 Dec 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
SQL Homework – December 2020 – Participate in the Advent of Code.
Christmas. Depending on where you live it’s a big deal even if you aren’t...
[Video] Azure SQL Database – Import a Database
By Arun Sirpal
Quick Video showing you have to use a BACPAC to “import” a database into...
Forums
Inflow / outflow report per day
Hello, I have two simple tables: Invoices InvoiceID Date Value and PaymentsReceived PaymentID Date...
If SQL Agent Job takes longer than @X minutes, get notified.
If Agent Job takes longer than @X minutes, we want to be notified. What...
Unable to create report in VS 2017
I have downloaded and installed Visual Studio 2017 and can connect to SQL Server...
Ask SSC