• You can combine the two thus

    SELECT CAST(CurrentDate AS DATETIME) + CAST(Time AS DATETIME) FROM Data

    This will be a DATETIME value. So you might use a CTE to combine the values then do the compare