I need help with writing about 3 hierarchical recursive query using either stored procedure or any other approach

Closed Posted 6 years ago Paid on delivery
Closed Paid on delivery

I have tables with hierarchical permission. For example:

Parent Folder/Child Folder /GrandChild Folder

if a user has permission to read the Parent Folder then the user should have read on Grand Child regardless of what is in Child Folder. The data is stored in different tables in a hierarchical manner. I need somebody to write a stored procedure or use some other mechanism to show which folder the user has access to. We need to limit the result so we can show paging.

MySQL SQL

Project ID: #16034076

About the project

12 proposals Remote project Active 6 years ago

12 freelancers are bidding on average $115 for this job

WebInfoSolutions

Do u want to write stored proc through .NET or php?.........................................................................

$147 USD in 3 days
(64 Reviews)
6.5
tsebro

Hello! I can help you with writing hierarchical recursing queries. I am professional Web Developer and co-owner of a web-development team with more than 15 years of experience in Website Development, PHP and MySQL. W More

$105 USD in 3 days
(2 Reviews)
4.9
bhupen2606

Hello, i have good experience with My SQL queries and stored procedures. Please let me know the table structures and result expected. Thanks.

$100 USD in 2 days
(20 Reviews)
4.2
mahmoud87hassan1

I am an experienced developer with close to 5 years experience in ASP.NET MVC and Web Forms,Web API work in the present. I also have a wealth of experience developing for a dynamic and responsive client side using adv More

$155 USD in 3 days
(2 Reviews)
3.0
rameshweb212

Hi, I am expert developer with 12 years of professional experience and very strong in writing sql queries for any requirement. I will make queries to access record as per permission. I need to discuss to understand More

$155 USD in 3 days
(7 Reviews)
3.0
buddhiabeyratne

Hi i understand your requirement is it possible to see your current database structure ? i can start work on it as soon as i get that paginating and stuff is going to be a breeze ill take care of that within the More

$35 USD in 1 day
(2 Reviews)
2.1
fastlabindia

We are highly experienced Post Graduate Engineers, Doctors, IT, ITES, Software, Infrastructure Professionals, Web Designers and IT Architects. We can redo, improve, and publish any engineering, scientific MATLAB, SI More

$30 USD in 1 day
(1 Review)
2.1
sunilmudunuri

I have 9 years of experience in SQL Server design, development and optimization. I have used Erwin tool for data modelling and i am well-versed with Normalization's for doing DB design Here is few technologies I ha More

$155 USD in 3 days
(0 Reviews)
0.0
dineshjoshi94

I am new to freelancing but having 3 year of experience. Recently I have write a same query as you need so I can complete this with low budget.

$111 USD in 3 days
(0 Reviews)
0.0