Question
I require a date and time variable to be created where the date component is the current date and the time component is 8:00AM.
Solution
DECLARE @myDTvariable smalldatetime = DATEADD(HOUR, 8, CAST(CAST(GETDATE() AS date) AS smalldatetime))