How to get the amount of elapsed minutes in current quarter in T-SQL

0 Comments

If you want to know the amount of elapsed minutes in the current quarter, you can use the following T-SQL code: declare @CurrentDateTime datetime = '2014-03-27 10:56:10' declare @MinutesPassedInHour int = convert(int, datepart(minute, @CurrentDateTime)) declare

Just a reminder: null = null, is not true in T-SQL

0 Comments

If you have a nullable column "Description" in one table and a nullable column "Description" in an other table and you join both tables on this column, records with both null in the field "Description"