Hi,
We have a DW in a tabpage and one has SELECT
statement as a source, something like this, for
example:
select A.col1, A.Col2, B.Col3
from table1 A, table2 B
where A.col1 = B.col1
and A.col1 = "X"
union
select A.col1, A.Col2, B.Col3
from table1 A, table2 B
where A.col1 = B.col1
and B.Col2 = "Y"
(The union has no sense is this example but I just
added as an example to give an idea of the original)
Originally this DW was only a report, but now the
user had the great idea to write Notes in a new
column.
The SELECT is kinda long and complicated and one of
our developers created a new table with the proper
Pk's and the Notes field, lets say table3. Right now
this table has no rows.
It's posible to show this new field in the DW, with
and outer join, but what we want to do is when user
type information in the Notes field insert a row Only
in this table3 from the DW.
Any ideas?
Should I use the multiple Update Service?
Thanks for your help, I'd really appreciate it
Jes
=====
~~~~~~~~~~~~~~~~~~~~~~~~
Jes�s Acosta P.
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~
Dance like no one's watching, love like you'll never be hurt, sing like no one's
listening, live like it's heaven on earth. -- William Pukey
__________________________________________________
Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
