如何从SQLServer中的另一个表中选择时间跨度为的日期时间

你的意思是:

select Start_Time, Finish_Time, absence.*
from time_setting ts
join absence a 
  on a.date_time>=floor(convert(float,getdate()))+convert(datetime,ts.start_time)
  and a.datetime<floor(convert(float,getdate()))+convert(datetime,ts.FinishTime)

我想你可以用这个:

SELECT UserID, Date_Time
FROM Absence AS A
INNER JOIN Time_Settings AS TS ON CAST (Date_Time AS TIME) >= CAST (Start_Time AS TIME)
                               AND CAST (Date_Time AS TIME) <= CAST (Finish_Time AS TIME)

SELECT  *
FROM    Absence_Table
    INNER JOIN  Time_Setting ON CONVERT(TIME,Date_Time) BETWEEN Start_Time and Finish_Time