@Date + cast(@Time as datetime)
In SQL Server 2012 and I assume SQL Server 2014 you neeed to cast both the date and the time variable to datetime.
cast(@Date as datetime) + cast(@Time as datetime)
@Date + cast(@Time as datetime)
In SQL Server 2012 and I assume SQL Server 2014 you neeed to cast both the date and the time variable to datetime.
cast(@Date as datetime) + cast(@Time as datetime)