>>Suhas
>>
>>Yoo don't need to sent the whole dbf - just the record structure (display struct) and a synopsis of what you want the SQL to achieve.
>>
>>Terry
>>
>
>hi terry,
>I am sending only a couple of months data I have taken off a years data. Total size would have been 14 MB above ziped. I want it to be fast thats why i have included a couple of months records.
>
>To which address should I send it to U?
>
>thanx
>
>suhashegde
Suhas
Like I said, sending your data to me would make no difference. I can see the table structures and what you want to do. You practically answered your own question, to wit:
>update bhav_data.delqty set delqty = del.delqty where bhav_data.symbol = del.symbol and
>bhav_data.series = del.series and bhav_data.date = del.date
update bhav_data ;
set delqty = del.delqty ;
where bhav_data.symbol = del.symbol ;
and bhav_data.series = del.series ;
and bhav_data.date = del.date
Does this do it?
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.