Alternatives to DATEDIFF_BIG in SQL Server 2014 for Comparing Previous Row Date Time with Current Row.

How to Filter Data Using SQL Date Ranges in SQL Server 2014

SQL Server's Most Concise Syntax for Returning Empty Result Sets