Login or Sign Up
- Logging in...
  
  Remember me
  
  Or
  
  Sign Up
  
  Forgot password or user name?
- Log in with

Search in titles only Search in posts by Ashumeerut only

Advanced Search

Forums
BYTES
Product Launch
Updates
Developer Toolkit

Member List
Calendar
Today's Posts

Home
Ashumeerut

User Profile

Collapse

Profile Sidebar

Collapse

Ashumeerut

Last Activity: Oct 8 '13, 04:27 PM

Joined: Oct 4 '13

Location:

Subscriptions2
Subscribers0

Activities
About
Media
Subscribed

Time

All Time Today Last Week Last Month
Show

All Discussions only Photos only Videos only Links only Polls only Events only
Source

All Ashumeerut only Visitor Messages Only Advanced

Filtered by:

new posts

Ashumeerut started a topic find total money of parent node of tree according to a particular pattern

in SQL Server

Oct 5 '13, 06:49 AM
find total money of parent node of tree according to a particular pattern
actually i am working on a project in which members are added in a tree pattern, and get the payment accordingly.

My tbltestingtree structure is ass follow:

Code:

Id ParentId IsLeft IsRight 1 Null Null Null 2 1 1 Null 3 1 Null 1

...
See more | Go to post
Ashumeerut replied to count total paired members of the tree by sqlquery

in SQL Server

Oct 5 '13, 06:39 AM
the answer is here :

http://stackoverflow.com/questions/1...ee-by-sqlquery

See more | Go to post
Leave a comment:
Ashumeerut started a topic count total paired members of the tree by sqlquery

in SQL Server

Oct 4 '13, 05:56 AM
count total paired members of the tree by sqlquery

I am having a table tbltestingtree representing the tree structure, Member_Id is the id of the member, Parent_Id represent the Parentid of that member , Lefts and Rights tells us that the member is attached to the left or right of the Parent.
**My problem is that i have to make a sqlquery that counts the total number of pared members for any particular parent ,**

Ex- currently member with id 1 has 3 pairs with id 2,3 and 4...

See more | Go to post

No activity results to display

Show More

Bytes
Help
Contact Us
Privacy
Terms of Service
Go to top

All times are GMT. This page was generated at 1 minute ago.

Working...

👍

👎

☕