User Defined ReOrdering in a SQL Server Table

  Suppose you want to allow your users to re-order a set of rows in a SQL Server table. Once the user has defined the new order, you need to save that order in SQL Server so that you can re-display the rows in the new order. But how can you accomplish this? You probably added a new column to the target table appropriately named sort. But how do you update this sort column so that it can reflect the new order? Let's assume we have 3 rows as follows and we have ORDER BY sort in query so that they display as... IDNameSort 1Red1 2Blue2 3Red3 and then our user re-orders the … [Read more...]