Archives of the TeradataForum

Message Posted: Fri, 15 Mar 2002 @ 16:27:09 GMT

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

I have a complicated update that I want to do on a table. It's far too complicated for SQL alone to handle but I believe a stored procedure would do the trick. I would like to write a procedure that takes each row from this table, puts it through a battery of logic, and then updates that row in the table. This is doable. However, my problem is that in order to do this, it seems that I am forced to use a cursor. This is too slow. I do not want the updates to happen one at a time. I'd like to combine the flexibility of procedure variables and manipulation with the speed of doing a "normal" update on a table. Is this possible with stored procedures? (Note: I'm asking if this is possible with stored procedures. I am fully aware that there are other methods to accomplish what I want.)

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