How do I calculate 7 level of complete binary tree

Question

1.00/5 (1 vote)

See more:

I have SQL table for Binary tree.

Id | Name | Parent_ID |

i want to calculate 5 levels of complete binary tree for parameter node which is passed to stored procedure.

What I have tried:

Recursive function
Using while loop

Posted 8-Jan-20 23:17pm

Member 14221689

Updated 9-Jan-20 1:03am

v2

Add a Solution

Comments

OriginalGriff 9-Jan-20 5:59am

So show us what you have tried, explain what it did that you didn't expect or didn't do that you did, tell us what you have tried to fix that.
Tell use where you are stuck, what help you need.

Use the "Improve question" widget to edit your question and provide better information.

Member 14221689 10-Jan-20 2:35am

Hi i Have already tried that, but i am confuse how exactly i can do that.

OriginalGriff 10-Jan-20 3:13am

Show us the code that didn't work, explain what it did.
Just hover your mouse over the question until you see "Improve question" in green at the bottom, and click it. That will let you edit the question and provide us with actual information.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Maciej Los · Answer 1 · 2020-01-09T01:04:00

Solution 1

For MS SQL Server, please read this: Hierarchies WITH Common Table Expressions | Microsoft Docs[^]

Posted 9-Jan-20 1:04am

Maciej Los