 |
 |
Archives of the TeradataForum
Message Posted: Thu, 21 Apr 2011 @ 14:32:42 GMT
| Subj: | | Re: Recursive Queries and Stored Procedures |
| |
| From: | | Dieter Noeth |
Simon Bloomer wrote:
| | Exactly. We can write recursive queries and views, no problem, This is basic SQL. But you can't use them in a STORED PROCEDURE, which
is something I stated in my original mail. | |
Sorry, i was under the impression you could access a recursive view in an SP. This was a really stupid limitation in TD12.
| | I was seeking advice an alternative way of achieving this so we can integrate it into SAP | |
Recursion can usually be rewritten using some loops: WHILE/REPEAT and INSERTs into a Volatile Table within the SP.
Or maybe you might be able to rewrite the logic using OLAP functions.
What's the original query?
Dieter
| |
