Reputation
309
Top tag
Next privilege 500 Rep.
Access review queues
Badges
4 18
Impact
~26k people reached

  • 0 posts edited
  • 0 helpful flags
  • 7 votes cast
Jan
15
awarded  Popular Question
Nov
10
awarded  Popular Question
Oct
19
awarded  Yearling
Aug
25
awarded  Notable Question
Aug
18
awarded  Popular Question
Jul
31
awarded  Popular Question
Jan
10
awarded  Popular Question
Dec
16
awarded  Notable Question
Sep
11
comment Using TOP and getting different result sets
Sorry, yes, missing some important info. Can't really post full table definition. OrderID is an IDENTITY column. A clustered index on OrderID.
Sep
11
accepted Using TOP and getting different result sets
Sep
11
comment Using TOP and getting different result sets
I think the most efficient method for me will be to add and ORDER BY OrderID clause. Michael Swart is approaching this in a very similar manner to me, which is reassuring.
Sep
11
comment Using TOP and getting different result sets
Thank you Aaron. This is fascinating. I see now my incorrect assumption that having orderID as primary key and clustered index, although it will physically order the data in a table, will not provide reliably ordered retrieval.
Sep
10
asked Using TOP and getting different result sets
Aug
23
awarded  Popular Question
Aug
8
awarded  Popular Question
Aug
4
awarded  Notable Question
Jul
30
accepted Restarting a Publisher involved in Merge replication
Jul
29
asked Restarting a Publisher involved in Merge replication
Jul
2
awarded  Curious
May
4
awarded  Popular Question