Date + Time 1

[drlex]

On the basis that your time is based on 1st Jan 1900 origin, I'd take the number of days since then from your date field and add them to the time field.

select dateadd(dd,datediff(dd,0,'2011-10-14 00:00:00.000'),'1900-01-01 09:00:00.000')

soi là, soi carré

 

[gmmastros]

1900-01-01 is the zero date, you so you could simply add the two columns together, like this:

declare @Temp Table([date] DateTime, StartTime DateTime)

Insert Into @Temp Values('2011-10-14', '09:00')

Select [date], StartTime, [date] + StartTime As NewDate
From @Temp

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[drlex]

George, how logical! And to think the OP had the answer in his question title "Date + Time". Star from me!

soi là, soi carré

 

[gmmastros]

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom