Interesting... now i've deleted old data and inserted again with the same date values as the previous deleted and now it works fine. Really dont now why is that happening.

Now...

Craig Farrell (2/17/2011)

---

Then your code should work. In the MyTable DDL, is [date] a field type of DATETIME, or is it VARCHAR() or something else?

There's no other reasons that...

Craig Farrell (2/17/2011)

---

Can you run this in a separate query window and tell me if you get one, or two, records back?

IF OBJECT_ID('tempdb..#MyData') IS NOT NULL

DROP TABLE #MyData

CREATE TABLE #MyData

([Date]...

Then please post your actual SQL, as I requested, and we might be able to help.[/quote]

select *...

Craig Farrell (2/17/2011)

---

If you're using my sample data/build, there's no records in the last 14 days then there was in the last hour, so that's correct.

If you're using your real...

Yes, I try to...

Thank you Craig, it works when i use:

select * from #cdata where cDate >= DATEADD( hour, -1, getdate())

...

CREATE TABLE dbo.cData (

ID bigint NOT NULL IDENTITY(1, 1),

[Value] float,

[Date] datetime

)

in Date field i...

hm... this query gets all data from table. My last record was inserted 08/02/2011 11:44:56 PM so

it must return zero rows because...