Stored Procedure Help Hierarchy Parent/Child Menu

已取消 已发布的 3 年前 货到付款
已取消 货到付款

I have a sql query/store procedure that I'm close on but can't get part of the child set to order correctly to the parent id and child id in a menu list.. attached is the project file to run and create the table, data, and stored procedure. This is a n-tiered hierarchy.

Create test DB in MSSQL [freelancer_test_menu]

Run data/scripts "[login to view URL]"

Execute "[login to view URL]"

SOLVE Sort Problem Parent name to line up above child names based on [ParentId]/ Child [ID] hierarchy

See [login to view URL] problem

SQL 微软 SQL 服务器 T-SQL (Transact Structures Query Language)

项目ID: #26488825

关于项目

2个方案 远程项目 活跃的3 年前

有2名威客正在参与此工作的竞标,均价$74/小时

aimsolutionspk

Hi, This shouldn't take much to be done as looks on paper but I haven't yet created the DB and tested it out. I'd be happy to give it a shot if you're interested. I've been writing complex stored procedures since las 更多

$80USD 在1天里
(12条评论)
6.8
anandan1995

I have a experience in asp.net, MVC, web API, c#, SQL, entity framework,linq, razor view (Cshtl), html, bootstrap,Angular JS, Jquery, Json,XML, reports (PDF,xls, crystal, rdlc,ssrs).

$67USD 在1天里
(14条评论)
3.4