Archives of the TeradataForum

Message Posted: Tue, 13 Aug 2002 @ 08:50:34 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Sreya,

Try this option, but i thing this will work up to some extend, if i am wrong please correct me.

insert into set (columna, columnb, coulumnc,columnd)

select columna,columnb,columnc,csum(1,1)
from multiset;

Regards,

Rajesh

N.D.Rajesh KumarSystech Solutions, Chennai

	<Prev	Next>		<<First	<Prev	Next>	Last>>