I often receive a very common question during my Comprehensive Database Performance Health Check about how to find Find Business Days Between Dates.
Today we are going to learn a very simple and interesting concept used very little. It is about how to Display Dates in Different cultures FORMAT.
Let us learn today how to CONVERT Empty String To Null DateTime. While I focus on SQL Server Performance Health Check, let us learn about it today.
We will see a very simple script where we will take advantage of the Common Table Expression and list all dates between two dates (Start and End Date).
One of my clients of Comprehensive Database Performance Health Check asked me a question about how to Convert Formatted Integer Values into Date.