Create a non clustered index on the field [Time] and then execute the query again.

You should have a clustered index on the table also.

I agree with the statement that the port of sql server i.e. 1433 should be blocked by the ISP. But can anybody tell me the way how to pass the...

Thanks Enthusiast,

I was really looking at the query like that. It really works.

It is really a great idea. But What I need is different. Suppose I have records like:

B

A

F

D

E

C

I dont want to sort them in ascending or descending order. But in the...