Re: Set a dinamic varable in query

On Wed, 18 May 2005 00:25:15 -0700, CJ wrote:

>I'm not sure that was the right answer to my question. But i tyr again.
>I want to a column to desribe a hierarchy .
>
>Here is my table:
>
>F1 F2 F3(my new colonne)
>10 text 10
>null text 10
>null tesxt 10
>12 text 12
>null tekxt 12
>null tete 12
>44 rwrw 44
>null hhkjh 44
>null tertre 44
>.......

Hi CJ,

Since you only repeated the same question with three extra example rows
tacked on to the end, I'm tempted to repeat my previous reply. But I'll
resist the temptation.

First, you obviously didn't follow the link I sent you. Please, follow
the instructions at www.aspfaq.com/5006 before you post again. If you
post CREATE TABLE and INSERT statements as outlined there, I can copy
and paste them to copy your test data to my test server. That makes
helping you lots easier!

Second, the extra sample rows still don't clarify the logic of your new
column. Take for example this row:
>null tertre 44
Why should the value in F3 for this row be 44? Why not 10, or 12, or any
other value?

If you answer that question, AND you post your table and data as CREATE
TABLE and INSERT statements as outlined in www.aspfaq.com/5006, then I
can try to help you further.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)
.