Archives of the TeradataForum

Message Posted: Fri, 05 Mar 2004 @ 10:58:34 GMT

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

Hello,

i'm just having a first trial with STORE PROCEDURE (V2R4 / Bteq ) and i experience some difficulties with a SELECT COUNT(*) INTO :param FROM TABLE WHERE condition;

is it possible to set a parameter with a count(*) result ?

the message reports an incorrect sql statement.

I am interested in help on the topic,

Thanks,

Pierre LUCAS

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