Ok On my application I have a photo with the persons name, the position they are and a description of them.
Then I have UP and DOWN arrows beside there names, then the user can move/put the photos in a specific order they want.
I want to be able to reorder the OrderBy column based on what they do.
My table is called Faculty_PhotoInfo with these columns:
So if the user selectes the up arrow I need the OrderBy to add +1 to the OrderBy column and -1 if they select the down arrow.
I have this query this far... by It is not right, I'm pretty stuck:
Create proc MoveFacultyMember
View Complete Post