WayneS (12/3/2010)

---

Well, the execution plan that you sent is just doing a "SELECT * FROM TestData". This results in a simple table scan of the TestData table. Which only tells...

WayneS (12/3/2010)

---

I don't see anything wrong with this query.

Questions:

1. What does the actual execution plan show?

2. How many records are in this table?

3. What indexes do you have on this...

Thanks for the reply.

I've PMed you the log, I hope you don't mind checking..

Thanks!