Get Free SQL Tips - SQL Server SELECT Tutorial

 Thank you very much. Great tutorial, specially on Inner Join. Overall, it is a big help and sums up a lot on books teaching SQL or T-SQL.

Big thank you

Sam,

I responded directly via email.

Thank you,
Jeremy Kadlec
Community Co-Leader

 I enjoyeed you tutorial but the real challenge is How do I perform TimeDifference column calculation ( 7:08: 48 - 6:36:56 = 00:31:52) and so on using SQL? I have done it in Excel and I want to perform it using SQL. Can you please provide your expertise?

Please pay attention the way TimeDifference column values are populated in Excel. It is tricky. My current SQL code generates StartTime, EndTime as shown and for TimeDifference I have 0:00:00 but I want to perform same Excel capability in SQL.

 StartTime     EndTime TimeDifference

    6:36:56    6:36:56          00:31 :52

    7:08:48    7:26:18          00:00 :23

    7:26:41    8:08:26          00:00 :09

    08:35.0    16:54.0          00:09 :42

    26:36.0    59:34.0          00:00 :09

    59:43.0    19:13.0         #VALUE!

Don't go to StackFlow since they don't have an answer.

Thank You.