TempDimDate

DELETE [dbo].[TempDimDate]
FROM [dbo].[TempDimDate]
    INNER JOIN [dbo].[DimDate] ON
        [dbo].[DimDate].[Date] = [dbo].[TempDimDate].[Date]
        AND
        [dbo].[DimDate].[DateTime] = [dbo].[TempDimDate].[DateTime];