I have a table which has one column called OrderBy.
by this column I sort the table record before showing them to the user.
User can change the order of records and then this column gets updated.
Now my client has told me to change the way user can reorder the records
He wants to simply puts a textbox and what ever value user enters in it should put the record at that position.
I am trying to write one common SP so that I can update the ORderby column by the value which user enters in the textbox.
Along with the updation of Orderby column I also need to keep the orderby column correct
so that no two records can have same orderby value.