Posted by Madhivanan on 04/21/06 13:55

Do you mean yesterday and today's data only?

Select * from yourtable
where datecol>=Dateadd(day,datediff(day,o,getdate()),-1)

Madhivanan

• Next in forum: Re: selecting a set for min value
• Prev in forum: Re: Any functions to replace NZ in SQL Server?
• Thread view: Re: Get all records from Last Two Days?

[Reply to this message]