Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #485

Re: Generating a tree structure from data

Show all headers | View raw

On Jun 22, 5:40 am, Steve <steve.simp...@aircelle.com> wrote:
> Hi,
>
> I've been banging my head against a brick wall trying to sort this and
> hoping somebody can help!!!
>
> i have a table that has 4  main fields;
> icode
> idcode
> parent
> iddesc
>
> parent is either blank, Y (meaning there are child links) and H
> (meaning it's the top level of a structure)
>
> icode is effectively the parent id and idcode is the child id
>
> iddesc is the description of the link
>
> I want to be able to create a procedure that recusively loops through
> the table (intradtl) and outputs an indented structure of the file
>
> Level    description
> .0         <<iddesc>>
> ..1        <<iddesc>>
> ....2      <<iddesc>>
> ..1        <<iddesc>>
> etc
>
> can anyone offer any advice on how to do it?  i want to do it in as
> simpler way as possible......
>
> thanks in advance

export your data out to a more logical table (temp) and run your query
there.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

Generating a tree structure from data Steve <steve.simpson@aircelle.com> - 2011-06-22 02:40 -0700
  Re: Generating a tree structure from data Erland Sommarskog <esquel@sommarskog.se> - 2011-06-22 22:18 +0200
  Re: Generating a tree structure from data --CELKO-- <jcelko212@earthlink.net> - 2011-06-23 07:36 -0700
  Re: Generating a tree structure from data rembrandt <batesbrandt@gmail.com> - 2011-06-29 04:47 -0700

csiph-web