#DateForumTypeThreadPost
809 Aug 2016 @ 01:38 PDTDatabaseTopicNumeric overflow occurred during computation in Teradata Stored procedure INSERT INTO TGT SELECT DECIMAL_C1, DECIMAL_C2, MAX(CAST(DATE_C3 AS DATE)) AS MAX_DATE_C3, MAX(CAST(TIMETSAMP_C4 AS TIMESTAMP(6))) AS MAX_TIMETSAMP_C4 (     SELECT&nb...
720 Jun 2016 @ 11:40 PDTUDAReplyHow to create a Macro passing table names as the parameterHi Dieter, I am having requirement where I want to use database_name and table_name as parameterized in stored procedure. In procedure I will be performing below DML operations :   INSERT ...
620 Jun 2016 @ 09:50 PDTDatabaseReplyDynamically select TOP N rows from tableThanks for helping to resolve the issue...!! :)
520 Jun 2016 @ 06:47 PDTDatabaseTopicDynamically select TOP N rows from tableHi All, I need to perform dynamically select TOP N row from table. SELECT TOP (10-4) COLUMNNAME FROM DBC.COLUMNS WHERE DATABASENAME='DATABASE_NAME' AND TABLENAME ='TABLE_NAME';...
420 May 2016 @ 06:04 PDTDatabaseReplyColumn value is refered as Column_Name in another tableHi All, I am getting spool space issue. Is there any other way to optimize the SQL for it? Thank you in advance.!
318 May 2016 @ 10:01 PDTDatabaseReplyColumn value is refered as Column_Name in another tableThanks for your reply..!! I thought we can do it dynamic way to fetch required field name. But as you said, there will not be any performance issues with huge CASE statements, I can go with this ...
218 May 2016 @ 06:10 PDTDatabaseReplyColumn value is refered as Column_Name in another tableHi dnoeth, There are C1 to C99 columns. I want to avoid writing CASE statement for 99 times. Can we perform it dynamic way? or using WITH RECURSIVE. Thanks for your reply.
118 May 2016 @ 05:05 PDTDatabaseTopicColumn value is refered as Column_Name in another tableHi, I am working on below requirement : In source table A there is field with XYZ. There is another source B table which is joined with A table on ID column. Now value pre...