Tags for select into
SELECT-INTO returns more than one row
Hi, I am far from new to database programming but totally new to Teradata and really struggling with stored procedures (amongst other things). I have a particular problem at the moment with a stored procedure failing with the error message "SELECT-INTO returned more than one row".
sql max() select into
How can I embed a WITH clause into a SELECT statement in Teradata 13.10?
More precisely: I want to use a WITH clause in a stored procedure's "SELECT ... INTO :variable FROM..." statement. ... DECLARE violatedRowsCount INTEGER; SELECT COUNT(*) INTO :violatedRowsCount FROM ( <_here_> ) AS TBL; ... Is it possible? If yes, how? Thanks!
stored procedure with clause select into