Date Difference

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…