One of our tables got corrupted, and we ended up pasting data back into the newly created one from an excel spread sheet. One problem though. . . our table was originally sorted in numerical order by a column we called "fID". But when we copied the data into the table, it's no longer sorted by that when we open it to view in sql management studio. How do we get it back to sort by that column, so that it looks like our original table??
sharc, in a relational database, there is no inherent order to rows. The only way to ensure rows in a certain order is to use the ORDER BY clause.
You can try to export the data, sort it in some fashion (possibly with Excel) and then loading the data back into the table. This may give you a display with the rows in an apparent order but there is no guarantee of this.