title: SQL statement to select all rows from previous day
body: <p>I am looking for a good SQL Statement to select all rows from the previous day from one table. The table holds one datetime column. I am using SQL Server 2005.</p>