Let me be a little bit more clear on that...

There are two columns

CurrentDate Date,

Time Varchar(10)

If I do , Select * from Data

Order By Date Desc , Time Desc shows the following results

The result is :

2014-03-26 3:01 AM

2014-03-26 2:01 PM

2014-03-26 2:01 AM

2014-03-26 12:01 PM

2014-03-26 12:01 AM

2014-03-26 11:01 AM *********** Shouldn't this be on top of :01 am?

I need to see the latest Date and Time in an order... If I resolve this I will be able to resolve my issue.