Click here to Skip to main content
15,891,943 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more: , +
I have created a tree view control which displays all the menu items of the page. Each menu item has menu_id, parent_id and menu level. I have written code for moving a menu item from under one parent menu item to another parent menu item. How to write a stored procedure to change the menu levels of all the moved menu items?
Posted
Comments
Abdul Quader Mamun 17-Mar-13 0:17am    
do you like to write SQL store procedure for that?
Sandeep Mewara 17-Mar-13 3:25am    
You ask how to write a SP or you seek for update query for your scenario? What stops you?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900