Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Random Index

Status
Not open for further replies.
sponges1

sponges1

Programmer
Aug 3, 2010
1
US
I have a stock ticker and all the symbols are in an index. They show up when I test it but they are random so the order changes when I refresh. How can I get it to go in the order in which I typed it?
 
Sort by date Sort by votes
In SQL Server there is no internal order - only using ORDER BY clause will give you the order you want.

You can add identity field to your table and order by this field.

PluralSight Learning Library
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

stanlyn
  • Locked
  • Question
Query for Next row based on an Index
Replies
17
Views
208
Olaf Doschke
Olaf Doschke
davism
  • Locked
  • Question
Index on Temp Table
Replies
7
Views
125
johnherman
johnherman
baran121
  • Locked
  • Question
table index problem?
Replies
13
Views
140
Olaf Doschke
Olaf Doschke
yorge
  • Locked
  • Question
Update a column with random value 2
Replies
1
Views
47
Olaf Doschke
Olaf Doschke
aidanopieri
  • Locked
  • Question
SQL Server Corrupt Index
Replies
1
Views
85
philhege
philhege

Part and Inventory Search

Sponsor

Back
Top