#DateForumTypeThreadPost
11911 Oct 2013 @ 11:46 PDTDatabaseReplyMinmum Time field selection - TIME(6)Hi, Try the following: SELECT MIN(TIME_COL) OVER(Partition by Date_Col Order By Time_Col) FROM TABLE_NAME;  
11811 Oct 2013 @ 04:04 PDTDatabaseReplySQL assistant - adding different serversHi, If you want to connect multiple servers using SQLA, you can do the following: Go to Tools->Options->General Check the Allow connections to multiple servers. Click ok ...
11710 Oct 2013 @ 11:33 PDTDatabaseReply"Problem Occurred" 'Handle Result Sets' has encountered a problem. GC overhead limit exceeded. I guess you are running this query from SQLA. Basically SQLA is used to analyze sample data and build queries on it. When you try to display large amounts of data, this error occures. This is basic...
11609 Oct 2013 @ 11:13 PDTDatabaseReplyConvert Teradata Mode Procedure to ANSI ModeYou need to change the Session Transaction mode to ANSI, and then recompile the procedure.   
11509 Oct 2013 @ 11:08 PDTDatabaseReplyCasting to An integer giving incorrect result.Well I have performed a lot of analysis at your problem. Following are some of my findings: The first thing is why are you enclosing a decimal value in qoutes? If you use the value without ...
11409 Oct 2013 @ 07:23 PDTDatabaseReplyHow to convert JAN 1, 2007 12:00:00 AM into timestamp format 'YYYY-MM-DDBHH:MI:SS' ???In fact when you want to convert a string literal to date or timestamp, it requires the literal in 'YYYY-MM-DD HH:MI:SS' format. So we have to convert the source data into this format. I ha...
11309 Oct 2013 @ 06:09 PDTDatabaseReplyTimestamp wit time zone conversioI think if you select the Timestamp column without normalizing, It will result according to your local Brazil time. Have you tried it?  
11209 Oct 2013 @ 04:59 PDTDatabaseReplyHow to convert JAN 1, 2007 12:00:00 AM into timestamp format 'YYYY-MM-DDBHH:MI:SS' ???Hi, What is the data type of source column? and is the source is Teradata database?  
11109 Oct 2013 @ 02:32 PDTDatabaseReplyCasting to An integer giving incorrect result.Diether, I have checked both in BTEQ, and SQLA, but it is giveing the same result. Can you please share your ODBC settings?  
11008 Oct 2013 @ 10:23 PDTDatabaseReplyHOw do you ALTER table add partitions on a multilevel partitioned table?You can try the following code: ALTER TABLE Table_Name MODIFY PRIMARY INDEX (col1,col2,col3) ADD RANGE BETWEEN DATE '2013-01-01' AND DATE '2013-12-31' EACH INTERVAL '1'...
10908 Oct 2013 @ 10:07 PDTDatabaseReplyHow to find a third lowest salary without RANK or TOP functionYou can find it using the following co-related subquery: SELECT * FROM Employee E1 WHERE n-1 = (SELECT COUNT(DISTINCT Salary_amount) FROM Employee E2 WHERE E1.Salary_amount > E2.Salary_Am...
10808 Oct 2013 @ 09:30 PDTCloud ComputingReplyvmware player: Free or not?!?Here is the answer to your question: http://www.vmware.com/products/player/faqs.html  
10708 Oct 2013 @ 09:27 PDTDatabaseReplySELECT INTO SQL inside stored procedureTitle is used to rename a column in Teradata, and it is Teradata extention. following is the syntax of Teradata for INSERT-SELECT. INSERT INTO ln_last_load_billing SELECT ZEROIFNULL(last_load_b...
10608 Oct 2013 @ 09:24 PDTDatabaseReplyCasting to An integer giving incorrect result.I think it is something realted to the range integer can handle. as if you remove one of the 0, the results appears to be fine. You can use decimal to avoid this error. SELECT cast('7014792...
10503 Oct 2013 @ 11:11 PDTDatabaseReplyQuery with TOP and COUNTHi, Try the following: SELECT TOP 10 col_name, COUNT(*) OVER () AS total_count FROM TABLE_NAME;  
10403 Oct 2013 @ 10:48 PDTGeneralReplyDifference between Product Join and Cartesian Product JoinCartesian product is simply a product join without any constraint (WHERE Caluse). Cartesion products are basically used for bench marking system performanc. else cartesien product should be avoided...
10303 Oct 2013 @ 04:16 PDTDatabaseReplyCASE statement in SQLUlrich,  You are very right, I have checked the type and the converted result is unicode, and it is creating the mess.  
10203 Oct 2013 @ 04:07 PDTDatabaseReplyCASE statement in SQLIs there any specific reason for involving Character data here? Why dont you use: COALESCE(ID,111)<> 123456  
10103 Oct 2013 @ 03:50 PDTDatabaseReplyCASE statement in SQLwhat os the type of data you have in the column? like you are writing constant 111, do you have a character data column or Integer?   
10003 Oct 2013 @ 02:43 PDTDatabaseReplyCASE statement in SQLCOALESCE is a short form of CASE, in your case it will be executed as CASE WHEN 111 IS NULL THEN '111' ELSE 111 END So the else part is returning Integer explicitly, and it is not equal...
9903 Oct 2013 @ 12:28 PDTDatabaseReply3932: Only an ET or null statement is legal after a DDL Statement. In BTET mode each individual statement is treated as a transaction, to combine multiple statements in transaction you need to use BTET. In case of DDL it is a requirement that each DDL statement mu...
9803 Oct 2013 @ 12:23 PDTDatabaseReplyCASE statement in SQLDo you think there is any difference between these two case statements? Both when conditions will be checking '111' = '111' as TD will implicitly convert 111 to '111' for co...
9702 Oct 2013 @ 02:50 PDTGeneralReplyOracle to Teradata SQL equivalents?Great! You can postback the working query as a help for others :)
9602 Oct 2013 @ 01:10 PDTGeneralReplyOracle to Teradata SQL equivalents?Hi, You are very close to the conversion. you can convert the two columns using the following format: SELECT CAST( CAST('2013-10-02' AS VARCHAR(10)) ||' '||CAST('02:41:30 +...
9501 Oct 2013 @ 09:49 PDTGeneralReplyOracle to Teradata SQL equivalents?You can use the following:   SELECT CURRENT_TIMESTAMP(0) - INTERVAL '1' HOUR; You can not subtract HOUR from date, thats why you will have to either use timestamp, Or co...

Pages