Converting dates/times to character and back is horribly inefficient, but if your table is small enough, it may still be fast enough to not significantly affect performance. Another option is the following.

SELECT DATEADD(DAY, DATEDIFF(DAY, 0, StartDate), CAST(StartTime AS DATETIME))

Drew