I wasn't sure if you needed to also account for holidays.  I came up with this approach that would account for holidays, but it does require a calendar table.  (You...

I used to use INFORMATION_SCHEMA exclusively, until I was trying to use them to quickly review the definitions of stored procedures and found out that the definitions are limited to...

There are two main options for this, and which one performs better depends on the typical number of records on the many side of the relationship.  The CROSS APPLY works...

The problem is that you are doing an implicit CROSS JOIN.  Here is the explicit version of what you are doing.

update tbl
set sequel = tbl.sequel_Inner

Wouldn't it be easier to just use the function designed specifically for this purpose?

SELECT CAST(DATEADD(SECOND, @time, '00:00') AS TIME(0))

Drew

The main issue is that the intervals in your second table aren't packed.  Here is an article that discusses Packing Intervals.

The approach I took was to pack...