>> I want to get multiple record [sic] from table and then sum all this

>> I want to sum all this text .. <<

"Owen" <anibal@prensa-latina.cu> wrote in message
news:uS8i1DxCFHA.960@TK2MSFTNGP09.phx.gbl...
> Hello:
>
> I want to get multiple record from table and then sum all this value and
> insert this result in other table like this:
>
> have one table with Id, RecNo and text, one article have only one id and a
> lot of RecNo, in each RecNo have a line of text. This is a old database. I
> want to sum all this text and insert in other table this Id and the
> complete
> text wihtout depend of recno and this separate lines.
>
> Best Regards,
> Owen.
>
>
>

"--CELKO--" <jcelko212@earthlink.net> wrote in message
news:1107560622.711697.35440@g14g2000cwa.googlegroups.com...
> >> I want to get multiple record [sic] from table and then sum all this
> value and insert this result in other table like this: <<
>
> Rows and records are TOTALLY different concepts. Since you did not use
> plurals correctly in your English, can I assume you are Asian and
> speak/write a language without them?
>
> >> I want to sum all this text .. <<
>
> Summation is a mathematical operation; adding words makes no sense.
> Did you mean concatenation?
>
> You will have to use a cursor to do the concantenation.
>
> Please post DDL, so that people do not have to guess what the keys,
> constraints, Declarative Referential Integrity, datatypes, etc. in your
> schema are. Sample data is also a good idea, along with clear
> specifications.
>