Work time calculation
One way to calculate how many minutes a person has worked considering holidays and shifts, being given starting and ending date / time
2016-09-29 (first published: 2016-09-08)
509 reads
DateFirst
Finding the Correct Weekday Regardless of DateFirst
In this article, learn how to get the correct weekday regardless of the DateFirst setting on your server.
2010-02-19
7,880 reads
Blogs
ASF 029: Tomaz Kastrun interview
By Kamil
Introduction Tomaž Kastrun is BI & DEV developer, data analyst & data science. With...
Schema Filtering in SQL Prompt
By Steve Jones
I love SQL Prompt, and I’m regularly impressed by the enhancements our teams continue...
Information Measurement with SQL Server Part 4.8: The Intersection Family of Distances
By Steve Bolton …………Each group of distance measures surveyed in this segment of the...
Forums
using the same logic across multiple servers/dbs
We have five different report servers, with 13 or so different databases, all with...
How to see the source SELECT statement of views?
I don't have permissions to right click\design views or to script the views. Is...
Error converting data type varChar to Float
Hello Everyone, I am running a really big code. At some point, I am...
Ask SSC