Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 647
  • Last Modified:

joe celko nested set model: how to compute the lft and rgt cols

Hi,

With reference to http://www.intelligententerprise.com/001020/celko.jhtml?_requestid=235427
I want the "sql stmt" which wud give the lft and rgt col values..

0
pai_prasad
Asked:
pai_prasad
1 Solution
 
LowfatspreadCommented:
> I want the "sql stmt" which wud give the lft and rgt col values..

for WHat?

the page actually gives examples of retrieving the common information sets..

ie who are my bosses?, who am i responsible for?

Is this a HOMEWORK question?

0
 
pai_prasadAuthor Commented:
my mistake ...i cudnt quite understand wats goin on in #6 ...
and the whole article is based on lft and rgt cols...so was confused how 2 derive those...
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now