Re: Nested Sets and custom sorting

From: Adam Machanic (amachanic_at_hotmail._removetoemail_.com)
Date: 08/04/04 

Date: Wed, 4 Aug 2004 10:20:38 -0400

"Mark" <mpluijmaekers@yahoo.com> wrote in message
news:37f9d092.0408032301.15abd4c9@posting.google.com...
>
> -- push when top has subordinates and set lft value
> INSERT INTO #Stack
> SELECT (@current_top + 1), MIN(T1.Nr), @counter, NULL, @level
> FROM #Stack AS S1, @Tree AS T1
> WHERE S1.child = T1.Parent
> AND S1.stack_top = @current_top;
>

    Mark,

    I'm still a bit confused; how do you get from your Contents table to
this point? Would it be possible for you to post some sample data (in the
form of INSERT statements - just enough to duplicate the problem) and the
complete code you're currently using to populate the tree?

Relevant Pages

  • Re: File Management
    ... Most of these files are duplicate / modified or updated version of the existing files. ... Due to this my server is having terabyte of data, ... Since there is big number of files, we need to walk the tree at least ... For, if the number of candidates is still not small you could make an additional refinement constructing a map with MD5s, until you get a small number of files and can compare their contents. ...
    (perl.beginners)
  • Re: family tree maker question
    ... I am told that there are no duplicate individuals. ... Search the Family Tree Maker Help menu for Duplicate for more ... Including duplicate descendants in Descendant trees and Descendant ...
    (soc.genealogy.computing)
  • Re: create query from unrelated tables
    ... the data has to be in a very specific order b/c ultimately it will be a comma ... Why not just create a query that filters and orders the records as you want them, instead of trying to populate a duplicate table? ...
    (microsoft.public.access.queries)
  • Re: Violation of Primary Key
    ... Maybe you could post your DML and sample data to reproduce the problem? ... You're trying to insert a duplicate ... making changes and I receive an error that says the following: ... > Violation of PRIMARY KEY constraint 'PK_CUSTOMERS'. ...
    (microsoft.public.sqlserver.server)
  • Re: How to: Remove duplicate TITLES but keep a COUNTRY code
    ... Please provide the table schema and sample data. ... > This works perfectly and removes any duplicate entries with the same TITLE ... country of ORIGIN codes such EEC - USA - CAN - DOM ...
    (microsoft.public.sqlserver.programming)