Stored Procedure Help Hierarchy Parent/Child Menu

Completado Publicado hace 3 años Pagado a la entrega
Completado Pagado a la entrega

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 Servidor de Microsoft SQL T-SQL (Transact Structures Query Language)

Nº del proyecto: #26488825

Sobre el proyecto

3 propuestas Proyecto remoto Activo hace 3 años

Adjudicado a:

(1 comentario)
1.4

3 freelancers están ofertando un promedio de $96 por este trabajo

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 Más

$80 USD en 1 día
(8 comentarios)
6.6
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).

$67 USD en 1 día
(10 comentarios)
2.8