Updating In-Memory Tables

The following works fine:

update "<XXX>"
set Value=Value/(Select Sum(Value) from "<XXX" where FundNo=1)*100
where FundNo=1

However, I can't get this to work to do all Funds at once ast it times out:

update "<XXX>" X
set Value=Value/(Select Sum(Value) from "<XXX" where FundNo=X.FundNo)
*100

Any help greatly appreciated.

"Ken Randall" <kenrandall@independentsoftware.co.uk> wrote in
news:400fc2a6@wic040d.:

> The following works fine:
>
> update "<XXX>"
> set Value=Value/(Select Sum(Value) from "<XXX" where FundNo=1)*100
> where FundNo=1
>
> However, I can't get this to work to do all Funds at once ast it times
> out:
>
> update "<XXX>" X
> set Value=Value/(Select Sum(Value) from "<XXX" where FundNo=X.FundNo)
> *100
>
> Any help greatly appreciated.


Hi Ken,

If you add an index to this Tempory Table for FundNo before doing the
query, does it work any better.?

eg..
CREATE INDEX ixFundNo
ON "<XXX>" (FundNo)



--
Keith Johnson [NDX]

It already has an index on it.

"Keith Johnson [NDX]" <keith{at}saxon.co.uk> wrote in message
news:Xns9478944576212Keithatsaxondotcodot@203.147. 131.213...
> "Ken Randall" <kenrandall@independentsoftware.co.uk> wrote in
> news:400fc2a6@wic040d.:
>
> > The following works fine:
> >
> > update "<XXX>"
> > set Value=Value/(Select Sum(Value) from "<XXX" where FundNo=1)*100
> > where FundNo=1
> >
> > However, I can't get this to work to do all Funds at once ast it times
> > out:
> >
> > update "<XXX>" X
> > set Value=Value/(Select Sum(Value) from "<XXX" where FundNo=X.FundNo)
> > *100
> >
> > Any help greatly appreciated.
>
>
> Hi Ken,
>
> If you add an index to this Tempory Table for FundNo before doing the
> query, does it work any better.?
>
> eg..
> CREATE INDEX ixFundNo
> ON "<XXX>" (FundNo)
>
>
>
> --
> Keith Johnson [NDX]

> However, I can't get this to work to do all Funds at once ast it
> times out:

A similar query works for me, most likely you need to increase your timeout
value on the query component.

I am not 100% sure this query is what you want; would you mind explaining in
words what the query is supposed to calculate?

--


Eivind Bakkestuen [NDD]
Please, no email unless requested.
Search Borland and third-party newsgroups here: www.tamaracka.com