Archives of the TeradataForum

Message Posted: Thu, 03 Jan 2008 @ 22:35:32 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi all,

I need a small help.

I will first brief abt the project requirement.

I have data as mentioned below

     PROD CD   PAREN PROD CD   XYZ_IND
     1              0             Y
     2              0             N
     11             1             Y
     13             1             Y
     22             11            Y
     24             11            Y
     80             22            N
     43             24            N
     51             2             N
     41             2             N
     90             51            N
     79             90            N
     09             79            N

When i select above records it should display like below

     ORD   PRODCD   PAREN PROD CD   LEVEL
     1       1           0            1
     2       11          1            2
     3       22          11           3
     4       80          22           4
     5       24          11           3
     6       43          24           4
     7       2           0            1
     8       13          1            2
     9       51          2            2
     10      90          51           3
     11      79          90           4
     12      09          90           4
     13      41          2            2

On the fly i need to arrange the records and introduce column ORD and LEVEL.

I am facing problem to arrange records according to above requirement.

Thx in advance.

	<Prev	Next>		<<First	<Prev	Next>	Last>>