Eurico Chagas Filho wrote:
> Hi
>
> I have this;
> INSERT INTO sTmp(Client, SldVal) values([Client01, 100.00)
> INSERT INTO sTmp(Client, SldVal) values([Client02, -200.00)
> INSERT INTO sTmp(Client, SldVal) values([Client03, 100.00)
> INSERT INTO sTmp(Client, SldVal) values([Client04, -100.00)
> INSERT INTO sTmp(Client, SldVal) values([Client05, 230.00)
> and i want to show this;
> Client01 100.00 Client02 -200.00
> Client03 100.00 Client04 -200.00
> Client05 230.00
> a client can appear on both columns and I could have only
> positives or negatives values.
>
> TIA, E.
>
Hola Eurico,
there is a way, if you can get two subselects one of positive and one
of negative (in the order you want) values with an extra column for the
"record number" (maybe you'll need a udf for this) and another subselect
with only "record numbers" (up to the max. record number). Then you'd do
a select from the record numbers left join the positive on record
number, left join the negative on record number, and voilá.
Probably not clear enough, sorry.
HTH
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
