Thread: ordering problem
View Single Post
  #5 (permalink)  
Old April 18th, 2008, 09:55 AM
todd2006 todd2006 is offline
Contributing Member

  
Join Date: Mar 2008
Posts: 188
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 1
todd2006 is an unknown quantity at this point
Default
Hi,

this works out

Code:
sqlstr="SELECT * FROM Topics WHERE (Convert(datetime,Hot_Topic_Date) <> (SELECT TOP 1 Convert(datetime,Hot_Topic_Date) FROM Topics WHERE Convert(datetime,Hot_Topic_Date) <= getDate() ORDER BY Convert(datetime,Hot_Topic_Date) desc)) order by Convert(datetime,Hot_Topic_Date) desc"