Hi,
I looking for good solution - please help me!
In my table there are two columns: date, time
In "where" I want to examine full datetime date+time.
Please give me good advice how to do it.
Thank you
Piotr
example for MS SQL2008
select 1,'2000-01-02','11:00'
select id,max(convert(varchar(20), tdate +' '+ ttime )) date
from #temp
Thank you
Piotr