3706 Syntax Error
Contents |
All communityThis categoryThis boardKnowledge baseUsers turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing results for Search instead for Did you mean: 3706 syntax error in teradata Teradata : Product Forums : Analytics : SELECT Failed. 3706: Syntax error: expected
3706 Syntax Error Expected Something Between An Integer And ')'
somet... Options Subscribe to RSS Feed Mark Topic as New Mark Topic as Read Float this Topic to the 3706 syntax error parse error Top Bookmark Subscribe Printer Friendly Page bdwebman Enthusiast Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 03-31-2011 12:25 PM syntax error expected something between ')' and ' ' 03-31-2011 12:25 PM SELECT Failed. 3706: Syntax error: expected something between '(' and the 'select' keyword. I am troubling over this error as I am not sure what the cause might be. Any help would be greatly appreciated.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,MaxScorefrom (select Id,
3706 Provider Cannot Be Found
max(Score) as MaxScore from (select Id, 'Fall', Fall_score from sandbox.testtable union all select Id, 'Spring', Spring_score from sandbox.testtable) a (Id, Category, Score) group by Id) bResult:SELECT Failed. 3706: Syntax error: expected something between '(' and the 'select' keyword. 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 Link Print Email to a Friend Report Inappropriate Content 03-31-2011 02:35 PM 03-31-2011 02:35 PM Re: SELECT Failed. 3706: Syntax error: expected something between '(' and the 'select' keyword. Which Teradata version are you using? Scalar subqueries in the select list were not supported until 13.0. 0 Kudos Reply bdwebman Enthusiast Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 03-31-2011 02:45 PM 03-31-2011 02:45 PM Re: SELECT Failed. 3706: Syntax error: expected something between '(' and the 'select' keyword. The DB version is 12 (SQL asst is 13). can you think of a way to rewrite this? 0 Kudos Reply bdwebman Enthusiast Options Mark as New Bookmark Subscribe Subscribe to
boardKnowledge baseUsers turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing results for Search instead for teradata 3706 syntax error data type Did you mean: Teradata : Product Forums : Database : Failed failure 3706 syntax error in teradata Query! Not sure why - 3706 Syntax Error? Options Subscribe to RSS Feed Mark Topic as New
Failure 3706 Syntax Error Column Name List Is Invalid
Mark Topic as Read Float this Topic to the Top Bookmark Subscribe Printer Friendly Page timloud Fan Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct http://community.teradata.com/t5/Analytics/SELECT-Failed-3706-Syntax-error-expected-something-between-and/td-p/62131 Link Print Email to a Friend Report Inappropriate Content 05-15-2012 05:30 PM 05-15-2012 05:30 PM Failed Query! Not sure why - 3706 Syntax Error? I'm trying to query our database by running the following SQL statement (see below) in Teradata SQL Assistant, but I keep recieving this error message - "Query Failed. [3706] Syntax Error. Data Type "cust_id" http://community.teradata.com/t5/Database/Failed-Query-Not-sure-why-3706-Syntax-Error/td-p/54351 does not match a Defined Type name" I've run this same SQL statement multiple times in the past, not sure why I'm having problems any suggestions for troubleshooting?... SELECT DISTINCT concat(a.cust_id,a.sell_to_loc_id), a.sell_to_loc_name, c.loc_street_txt, c.city_name, c.state_cd, c.ctry_cd, c.zip_cd FROM edward.active_cust_plate a JOIN edward.cust_loc c ON a.cust_srce_cd = c.cust_srce_cd and a.cust_id = c.cust_id and a.sell_to_loc_id = c.cust_loc_id JOIN edward.account_grps g ON a.cust_id = g.cust_id WHERE (g.acct_grouping_lvl_cd = 'C' and a.cust_srce_cd = 'C') AND g.acct_grp_cd IN ('BEALL''S DEPT STORES INC', 'BELK', 'BOB STORES CORP', 'BON-TON DEPT STORES INC', 'BOSCOVS DEPT STORE INC', 'DILLARD''S', 'FRED MEYER STORES INC', 'JC PENNEY CORP INC', 'KOHLS DEPT STORE', 'MACY''S HEADQUARTERS', 'NORDSTROM', 'SEARS ROEBUCKCO', 'STAGE STORES INC') AND CASE c.loc_clsd_dt WHEN '1582-01-01' THEN NULL ELSE c.loc_clsd_dt END > '2010/04/22' AND a.sap_sell_to_loc_type_cd = 'Z02' AND a.cust_mail_addr_name_1 not like '%CLOSED%' AND a.cust_id != '91450' AND c.state_cd != 'PR' AND c.state_cd != 'GU' AND a.sell_to_loc_name not in ('PARISIAN INC','GOODY''S','CHUGIAK-EAG
here for a quick overview of the site Help Center Detailed answers to any questions you might have http://stackoverflow.com/questions/33881680/select-failed-3706-syntax-error-expected-something-between-and-the-end-of Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, syntax error just like you, helping each other. 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 Error code '3706'. Looks to be something with a comma in my syntax. Tried to strip the code down 3706 syntax error as much as possible, yet still getting the error. My SQL is below. Using Teradata as well. Any ideas? Thanks for the help. SELECT work_order_number, sub_type_level_2, reporting_region, [create_date]+7-Weekday([create_date],7) AS WE, create_date FROM rpt_v_dm_all_work_orders GROUP BY work_order_number, sub_type_level_2, reporting_region, create_date HAVING (((reporting_region)='Pacific') AND ((create_date) Between Date()-16 And Date()-3)); sql vba teradata share|improve this question edited Nov 23 '15 at 22:26 Aaron Dietz 1,6911116 asked Nov 23 '15 at 22:11 Dkratzer 11 Please format your code using { }. –Kamil G. Nov 23 '15 at 22:21 1 This is no Teradata code, there's no [..] and no function named weekday. You might use NEXT_DAY to find the next weekend... –dnoeth Nov 23 '15 at 22:53 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote I've formatted your code and removed some redundant parentheses. I've added max() on a column you don't have in your GROUP BY statement as well. Please try this: SELECT work_order_number, sub_type_level_2, reporting_region, max([create_date]+7-Weekday([create_date],7)) AS WE, cre