View Single Post
  #10 (permalink)  
Old August 25th, 2006, 12:46 AM
Peso Peso is offline
Friend of Wrox
 
Join Date: May 2006
Location: Helsingborg, , Sweden.
Posts: 246
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Or

SELECT *
from table_name
where CreationDate BETWEEN @CreateDate AND DATEADD(day, 1, @CreateDate)
        AND ID = Number


Reply With Quote