DBA and DataScience

  • SQL Server
    • SQL Backup Recovery
    • SQL Security
    • SQL Performance
  • DataScience
    • Python
  • About Me

Date Difference

TSQL

Calculate date difference of 2 consecutive rows of a column – TSQL

I came across a situation where I had to write a query to calculate difference of 2 rows of datetime column based on a condition of another field.  I was troubleshooting performance issues of few stored procedures which are setup as series of steps in a SQL Job. Hence I had setup Read more…

By harimindi, 2 years2 years ago
Categories
  • DataScience (10)
  • Python (5)
  • SQL Backup Recovery (1)
  • SQL Performance (9)
  • SQL Security (4)
  • SQL Server (17)
  • TSQL (2)
Recent Posts
  • SQL Job resume automatically after server restart
  • Linked Server Double-Hop Issues with SQL Server
  • Calculate date difference of 2 consecutive rows of a column – TSQL
  • Verify TLS 1.2 Connections from SQL Server
  • SQL VDI Errors
Contact Email:
  • harikumar.mindi@gmail.com
  • About Me
  • Contact Me
  • Data Science
  • Posts
  • Python Scripts
  • Scripts
  • SQL Server
Hestia | Developed by ThemeIsle