#DateForumTypeThreadPost
13706 Sep 2013 @ 10:34 PDTAnalyticsReplysubstring(accno,7,10)I think your SQL would give you the integer extracted out of your forecast_version_number field. If you want to extract characters from the forecast_version_number field, you could do SUBSTR from ...
13606 Sep 2013 @ 10:27 PDTDatabaseReplyLeading Spaces in answer set in SQLAWhat if you use TRIM ?
13521 Aug 2013 @ 10:11 PDTDatabaseReplyWeekday and Time functionTo find out the weekday of a date, you can use - SYS_CALENDAR.CALENDAR To compare the time variable with the constant value, you can put the constant value in the quotes as you did in your example...
13421 Aug 2013 @ 10:03 PDTAnalyticsReplygroup the records based on dateAre you saying the solution that I provided wouldn't work for you ?
13315 Aug 2013 @ 01:52 PDTAnalyticsReplygroup the records based on dateWhy you want to make such complicated ? What i understood from your desired output, you can get it done easily just by - Select ID, TYPE, MIN(STDT), MAX(ENDT) From Table group by 1,2.
13215 Aug 2013 @ 01:15 PDTDatabaseReplyDeleting duplicate rows in multiset tableIf you do not want to create any intermediate table then you can add another column and can use RANK or ROW_NUMBER and then use QUALIFY to delete duplicate record.
13115 Aug 2013 @ 01:09 PDTDatabaseReplyCombine Multiple Select StatementsYou can do UNION ALL between all these queries and get 7 rows in one answer sheet in one shot.
13009 Jun 2013 @ 10:23 PDTToolsTopicTPT Kill Job ErrorHi, I have just started using TPT and was loading one empty table from one environment to another. It was taking longer than usual so I killed the job using 'Kill job' option on TPT screen....
12923 May 2013 @ 10:46 PDTTeradata StudioTopicGeneral stuff with StudioHi, I have few questions on Teradata Studio that I installed just couple of days ago. 1) How do I copy the answer set in excel by using 'copy and paste' ? If I do that, it puts the whole r...
12815 May 2013 @ 06:19 PDTDatabaseReplycalling a SP inside a SP.I think the error that you get is not about the access at the user level, but at the database level. database 1 (temp) doesn't have execute procedure access to database 2 (temp1)...
12714 May 2013 @ 10:39 PDTDatabaseReplyHow to update the duplicate records in TeradataYou can use row_number to assign different numbers to each perfectly duplicate rows and then update 1 columns of 1 row by putting filter condition like row_number = 1
12610 May 2013 @ 05:45 PDTDatabaseReplyMacro default valueNot sure about SP, but if you have to pass the default parameter to SP, you can use macro to pass default parameter and call SP from the macro.
12508 May 2013 @ 10:30 PDTDatabaseReplyinsert into one table from multiple select statements and multiple tablesI am not sure if I got your question here. What is the issue ? I think you want to insert the data into one table from multiple tables, but using one select ? please clarify your question and will ...
12430 Apr 2013 @ 10:32 PDTDatabaseReplyRecursive ViewI agree with the fact that recursive queries are slow as it takes lot of spool but for only 70K employees, it should not take that long. We process 100 of thousands of records with i...
12326 Apr 2013 @ 05:52 PDTDatabaseReplyProblem with AliasesThe only thing I do not understand from your query is the space between database2.table and 1 (same way with table 2). But I assume it is typo and you really meant table1 and table2. Are you sure ...
12224 Apr 2013 @ 10:24 PDTDatabaseReplyVolatile table V/S Perminent tableThese all tables that you mentioned keep the data temporarily with different purpose. If you are looking to store the data permanently then you should not use either of these kind. Let us know...
12121 Apr 2013 @ 06:09 PDTData ModelingReplyConverting Rows to ColumnsTry to use WITH RECURSIVE to do the row to column conversion, that would be neat, faster and dynamic. 
12021 Apr 2013 @ 05:58 PDTGeneralReply'If' .. Then statement in Teradata ? The option you put would work for sure, there is one more way you can do it - COALESCE(NULLIFZERO(Billed_Amount),'No_Charge')  
11918 Apr 2013 @ 10:26 PDTDatabaseReplyNeed Help on two questions about TD architectureFor question 1, node is the correct answer. For question 2, I think AMP is the correct answer, but not 100% sure. Good luck !
11815 Apr 2013 @ 11:45 PDTToolsReplyTools and UtilitiesAs I kept my thinking cap still on, got one idea. I think (not 100% sure though), you can achieve N+10 records using BTEQ if you use .SET RETLIMIT = 10 along with the SKIP optio...
11715 Apr 2013 @ 11:34 PDTToolsReplyTools and UtilitiesIn Fastload, you can use options like RECORD and THRU to load the rows fro Nth record to N+10. For BTEQ, I am aware of SKIP option that would allow you to load from the Nth record, ...
11612 Apr 2013 @ 09:59 PDTGeneralReplyTeradata error 3610 Internal error: Please do not resubmit the last request. SubCode, CrashCode: 0, 3701You mentioned that when you run from different user in SQLA, it works fine. I have 2 questions, do you face the same problem when you run your query with a different user in BO and not in SQLA or ...
11511 Apr 2013 @ 06:16 PDTGeneralReplyBLANK FROM SOURCE IS CONVERTED TO 0 while loading into TableI think you can still have BLANK values in the INTEGER column if you INSERT without quotes, like - INSERT INTO TST_TABLE(col1,col2,col3) values(20,,20); (assuming there is no DEFAUL value to this c...
11411 Apr 2013 @ 06:04 PDTGeneralReplySummarize the total by categoryYou are not supposed to GROUP BY on all the columns of your select when you are doing SUM. Just do GROUP BY on the first column and you should get all the metrics at the category level.
11310 Apr 2013 @ 10:44 PDTDatabaseReplyCast from CHAR(20) to SMALLINTIt should not throw any errors if you are inserting the records as per the first post. Can you share the query that is giving you the problem and will look into it.

Pages