#DateForumTypeThreadPost
527 May 2015 @ 11:35 PDTDatabaseTopictranforming a procedure into functionI have a procedure in Teradata, which I want to execute at the select statenent. For that I assume I have to call my procedure into a function and then use query such as Sel schema.user_func(in...
413 Jan 2015 @ 12:21 PSTDatabaseReply2616 error numeric overflow with row_number() Thank you so much dnoeth.. Your second query worked. Can you please tell what it is doing if you don't mind.
312 Jan 2015 @ 08:34 PSTDatabaseTopic2616 error numeric overflow with row_number() I'm trying to select a table having 238,21,78,900 records and I m generating sequence number with that as mentioned below. Select cast(row_number over(order by col_name) as bigint From table...
204 Dec 2014 @ 09:39 PSTDatabaseReplyCreate multiple tables using select statementThanks for the kind feedback Ulrich That's what I had in mind. To create a reference table and call the table name inside a procedure. But that's what I want to ask. How to do that? How to ...
103 Dec 2014 @ 11:18 PSTDatabaseTopicCreate multiple tables using select statementHello everyone I am new to this community.   Ok, So what i want to do is that i want to create multiple table using select statement from multiple tables. Something like this:   Crea...