在SQL Server中的两列上执行双重排序，主要排序不在前两个的评估中

I have a table using SQL Server 2008 it has a table with two sortable columns on it one is manually set and the other is calculated by a system procedure (this procedure sorts everything as a whole and assigns a sort starting at 10 until the highest row number times 10)I have a table using SQL Server 2008 it has a t