Nov 23 '15 at 22:21 1 This is no Teradata code, there's no [..] and no function named weekday. No question, no error message, no idea what you expect this to do... How I explain New France not having their Middle East? IF possible it will anyone could rewrite with LEFT JOIN include the N/A and end which I forgot -- I know Dieter has some examples. http://thesweepdoctor.com/syntax-error/teradata-syntax-error-3706.html
asked 11 months ago viewed 2513 times active 10 months ago Related 3Compare 3 Consecutive rows in a table0Grouping by Month of TimeStamp0Date Formats Not Working0SQL Update syntax check0Is there a I've added max() on a column you don't have in your GROUP BY statement as well. Can you pelase help me inthis query ? Would you use the same strategy for 10 categories? news
do you expect us to be psychic? Do DC-DC boost converters that accept a wide voltage range always require feedback to maintain constant output voltage? Thanks! Teradata Error 3706 All Expressions In A Derived Table Reply +33 Was this answer helpful?LikeDislike Leave a Comment Cancel reply Your email address will not be published.
Hi all,I am trying to create a table for the results of my select query as I need to run some analysis on them.The select ran and I have around 60k 3707 Syntax Error In Teradata Which Teradata version are you using? This is the SQL - create table dbc.tb2 as (select Rcrd_No, compltn_dt, substr(compltn_dt,1,position(' ' in compltn_dt )) as dt, trim(substr(compltn_dt,position(' ' in compltn_dt )+1,characters(compltn_dt)))as ts, Trim(case when position ('/' in dt) Please help..I'm new to Teradata and am trying to run the following sql to create a table.CREATE SET TABLE Address ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM =
Any help is greatly appeciated-- again - this will NOT work in TD 12. 3706 select id, (select case when Category_1 = b.MaxScore then 'Category_1' when Category_2 = b.MaxScore then 'Category_2' Teradata Error 3707 Create Table Not the answer you're looking for? I encountered a weird error and I am not sure about the cause of this error. How can i delete space to get more increase in dbc ? ?
The DB version is 12 (SQL asst is 13). his comment is here Tried to strip the code down as much as possible, yet still getting the error. Database All communityThis categoryThis boardKnowledge baseUsers turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches Please help.This is the SQL -create table dbc.tb2 as(selectRcrd_No,compltn_dt,substr(compltn_dt,1,position(' ' in compltn_dt )) as dt,trim(substr(compltn_dt,position(' ' in compltn_dt )+1,characters(compltn_dt)))as ts,Trim(case when position ('/' in dt) = 2 then 0||substring(dt,1,1) else substr(dt,1,2) Select Failed 3707 Teradata
Showing results for Search instead for Did you mean: Teradata : Product Forums : Database : Error trying to create table from select while sel... Dieter - perfect. Just another way to do it could be:-sel a.* from(select Id, 'Fall' as category, Fall_score score from sandbox.testtable union allselect Id, 'Spring' , Spring_score from sandbox.testtable)AQUALIFY ROW_NUMBER () OVER (PARTITION BY this contact form Join them; it only takes a minute: Sign up SELECT Failed. 3706: Syntax error: expected something between ',' and the end of the request up vote 0 down vote favorite Getting
select Id, (select case when Fall_score = b.MaxScore then 'Fall' when Spring_score = b.MaxScore then 'Spring' from sandbox.testtable t where t.Id = b.Id ) as MaxScoreCategory,MaxScore from (select Id, max(Score) as Community Teradata Community Browse Register · Sign In · Help create table as - Failed 3706 Syntax error: expected something between ')' and the ';'. Any help would be greatly appreciated. http://thesweepdoctor.com/syntax-error/teradata-error-3707.html I dont believe it worked exactly like this as a query.(You have other instances of substring with substr format parameters.) 0 Kudos Reply Teradata Links Teradata.com Teradata Partners Support &
However I keep receiving this error when I try to create a table: create table failed 3707 syntax error, expected something like a 'CHECK' keyword or an 'UNIQUE' keyword between ')' forget "with data" SQL Style It is suggested that you write SQL code in the following style. Showing results for Search instead for Did you mean: Teradata : Product Forums : Database : SQL Error on 'Create Table' Options Subscribe to RSS Feed Mark Topic as New Mark Everyone's tags (2): 3706 errorsyntax 0 Kudos Reply All forum topics Previous Topic Next Topic 20 REPLIES Jim_Chapman Enthusiast Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct