#DateForumTypeThreadPost
2926 Aug 2013 @ 07:32 PDTConnectivityReplyWorking with BLOBs with ADO (VB)Hi everyone,   I want to use ADO to connect to Terradata Server. I have Teradata.Net and ODBC installed. I have been using ODBC and SQLA but now I need to be able to work with VB 6. &...
2825 Aug 2013 @ 07:07 PDTDatabaseReplyvolatile table as select..with data - not loading dataThanks Qaisar for the vote of confidence.  
2725 Aug 2013 @ 09:32 PDTDatabaseReplyvolatile table as select..with data - not loading dataThanks for everyone help. Here is the Functional Code for Update Query but I still need some Logic Help I am going to put here hoping someone have an guide me in a right direction. I do not have a...
2623 Aug 2013 @ 05:28 PDTDatabaseReplyvolatile table as select..with data - not loading dataI am thinking may be use Insert into Temp1(temp_1.Q1Count) SELECT CAST(RP.REGIS_DATETM AS DATE) AS MyDate, COUNT(DISTINCT RP.REGIS_PRSNA_ID) AS Q1Count ...
2523 Aug 2013 @ 05:20 PDTDatabaseReplyvolatile table as select..with data - not loading dataI tried creating a table that didn't work, then I try updating a Table that didn't work. Teradata VS Oracle very different. Please some help as I am lost No Syntax is working. UPDATE te...
2423 Aug 2013 @ 08:51 PDTDatabaseReplyvolatile table as select..with data - not loading dataOh, Barani I removed that statement but I still have the same issue Create Table Failed 3706 Syntax Error:expected something between the word "RP" and ".". and I have no idea @ ...
2323 Aug 2013 @ 07:46 PDTDatabaseReplyvolatile table as select..with data - not loading dataDieter and Abhijit Thanks. I did read the thread but I guess I missundersttod the error and asked the Wrong question. Query Line 17:AND RP.REGIS_DATETM BETWEEN (CURRENT_DATE -7) and CURRENT_DATE ...
2222 Aug 2013 @ 04:40 PDTDatabaseReplyvolatile table as select..with data - not loading data How do I create a Table from Select Query with Data? Below is my Query and Table I want to create? create table TWM_SANDBOX.tbl1_frm_qry1 as ( SELECT CAST (RP.REGIS_DATETM AS DATE), COUNT...
2122 Aug 2013 @ 04:32 PDTDatabaseReplyCombine Multiple Select StatementsThanks Dieter, The code is not working, I made a little change. SELECT t1.datetm, t1,cnt, t2.cnt FROM ( SELECT COUNT(DISTINCT RP.REGIS_PRSNA_ID) AS cnt, CAST (RP.REGIS_DATETM AS DATE) ...
2022 Aug 2013 @ 03:35 PDTToolsReplyImporting Data from file with sql assistantI'm using SQLA 13.11.0.03 August 12, 2011 ODBC 13.10.00.06 Database Version Teradata 13.10.0511 13.10.05.11 I have coma delimited CSV with No headers. When I try to import it in a Table th...
1919 Aug 2013 @ 11:00 PDTAnalyticsReplyREPORT FROM MULTIPLES QUERY BEST APPROACH create table failed 3706 Syntax error data Type "chracter" does not match a define type name?? Why am I getting this error?
1819 Aug 2013 @ 10:48 PDTAnalyticsReplyREPORT FROM MULTIPLES QUERY BEST APPROACH Kindly Guide me ..I will be highly obliged!   Regards,   J
1719 Aug 2013 @ 10:47 PDTAnalyticsReplyREPORT FROM MULTIPLES QUERY BEST APPROACH CREATE SET TABLE Schema.MASTER_TBL,NO FALLBACK No BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM=DEFAULT, DEFAULT MERGEBLOCKRATIO (Col1 CHAR(3) CHRACTER SET LATIN NOT CASESPECIFIC NOT NULL d...
1619 Aug 2013 @ 10:45 PDTAnalyticsReplyREPORT FROM MULTIPLES QUERY BEST APPROACH Expected OutPut Without Query Columns: Region Country Brand KPI Source System F-Target Brand/Market Date NA Brazil PPP Opt - All (2, TT) (2,TT) weekly TTT-CA 8/14/2013 NA Brazil PPP Opt - All ...
1519 Aug 2013 @ 10:34 PDTAnalyticsReplyREPORT FROM MULTIPLES QUERY BEST APPROACH Step2:   Insert all Fixed Values in a Table for 7 days along with Date Field. This Query Execute on 08/20/2013.   I want to Learn how to use CURSOR to loop through each...
1419 Aug 2013 @ 10:32 PDTAnalyticsTopicREPORT FROM MULTIPLES QUERY BEST APPROACH I do not know the Best Approach and I am a total Newbie with databases and SQL. Learing from Several Platfrom.   I have to create a Report by pulling data from database Views and ex...
1319 Aug 2013 @ 09:59 PDTUDAReplyCREATE NEW TABLE with COLUMNS FROM four QUERIES + CONSTANT FieldsDoes above Syntax for Creating Permenant Table Structure looks correct? Step2: Insert all Fixed Values in a Table for 7 days along with Date Field. This Query Execute on 08/20/2013. I want to Le...
1219 Aug 2013 @ 09:59 PDTUDAReplyCREATE NEW TABLE with COLUMNS FROM four QUERIES + CONSTANT Fields CREATE SET TABLE Schema.MASTER_TBL,NO FALLBACK No BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM=DEFAULT, DEFAULT MERGEBLOCKRATIO (Col1 CHAR(3) CHRACTER SET LATIN NOT CASESPECIFIC NOT NULL d...
1119 Aug 2013 @ 09:58 PDTUDAReplyCREATE NEW TABLE with COLUMNS FROM four QUERIES + CONSTANT FieldsI do not know the Best Approach and I am a total Newbie with databases and SQL. Learing from Several Platfrom. I have to create a Report by pulling data from database Views and exporting it into E...
1019 Aug 2013 @ 07:08 PDTDatabaseReplyCombine Multiple Select StatementsThanks for your response. What is the Syntax for derived table query? How do I Union derived table query?  Thank you for your help!
915 Aug 2013 @ 03:40 PDTDatabaseReplyCombine Multiple Select StatementsUnion Work but it doesn't give me what I want. I think what I may be looking for is something I have found in Oracle but not sure how would I use it in Teradata SQL http://www.oracle-develope...
815 Aug 2013 @ 12:00 PDTDatabaseReplyCombine Multiple Select StatementsLooking forward for all the help I can get, Appreciate it in Advance.  
715 Aug 2013 @ 11:57 PDTDatabaseReplyCombine Multiple Select Statements SELECT (COUNT (DISTINCT RP.REGISTER_ID), CAST (RPE.CEMAIL_DATETM AS DATE) FROM SCHEMA_1.REGISTER_TBL RP INNER JOIN SCHEMA_2.MPROGRAM MP ON RP.MPRG_NBR= MP.MPRG_NBR INNER JOIN ...
615 Aug 2013 @ 10:48 PDTDatabaseTopicCombine Multiple Select Statements How do I combine multiple Select queries? I have 7 queries run separately. Each query return 2 columns. Count(of something), (date) Date Range is Fixed for each query Set to 1 Week only....
508 Aug 2013 @ 10:14 PDTDatabaseReplyWhat's the quickest way to find out all the values under an attributesDieter thanks alot. Found your another Post where you have explained it all!  Great!

Pages