Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Unable to parse query text.

Author  Topic 

BrOkEn_iCe
Starting Member

25 Posts
Posted - 2010-06-23 : 05:07:25
i have error "Unable to parse query text." when i run this query in view

and this error "Msg 102, Level 15, State 1, Line 7
Incorrect syntax near '='.
" when i run it in the query panal


SELECT
              area_code, cycle_no, sum(v101) AS val101, sum(v102) AS val102, sum(v103) AS val103, sum(v104) AS val104, sum(v105) AS val105,
               sum(v401) AS val401, sum(v901) AS val901, sum(v902) AS val902, sum(v903) AS val903
FROM 
             [SELECT 
                           area_code, cycle_no,
                           ( CASE WHEN ([add_code]= 101) THEN ([add_val]) ELSE (0) END ) AS v101,
                           ( CASE WHEN ([add_code]= 102) THEN ([add_val]) ELSE (0) END ) AS v102,
                           ( CASE WHEN ([add_code]= 103) THEN ([add_val]) ELSE (0) END ) AS v103,
                           ( CASE WHEN ([add_code]= 104) THEN ([add_val]) ELSE (0) END ) AS v104,
                           ( CASE WHEN ([add_code]= 105) THEN ([add_val]) ELSE (0) END ) AS v105,
                           ( CASE WHEN ([add_code]= 401) THEN ([add_val]) ELSE (0) END ) AS v401,
                           ( CASE WHEN ([add_code]= 901) THEN ([add_val]) ELSE (0) END ) AS v901,
                           ( CASE WHEN ([add_code]= 902) THEN ([add_val]) ELSE (0) END ) AS v902,
                           ( CASE WHEN ([add_code]= 903) THEN ([add_val]) ELSE (0) END ) AS v903,
              FROM add_trans ]

GROUP BY area_code, cycle_no;



thx

Sachin.Nand

2937 Posts
Posted - 2010-06-23 : 05:10:09
See the part marked in red below.


SELECT
              area_code, cycle_no, sum(v101) AS val101, sum(v102) AS val102, sum(v103) AS val103, sum(v104) AS val104, sum(v105) AS val105,
               sum(v401) AS val401, sum(v901) AS val901, sum(v902) AS val902, sum(v903) AS val903
FROM 
             [SELECT 
                           area_code, cycle_no,
                           ( CASE WHEN ([add_code]= 101) THEN ([add_val]) ELSE (0) END ) AS v101,
                           ( CASE WHEN ([add_code]= 102) THEN ([add_val]) ELSE (0) END ) AS v102,
                           ( CASE WHEN ([add_code]= 103) THEN ([add_val]) ELSE (0) END ) AS v103,
                           ( CASE WHEN ([add_code]= 104) THEN ([add_val]) ELSE (0) END ) AS v104,
                           ( CASE WHEN ([add_code]= 105) THEN ([add_val]) ELSE (0) END ) AS v105,
                           ( CASE WHEN ([add_code]= 401) THEN ([add_val]) ELSE (0) END ) AS v401,
                           ( CASE WHEN ([add_code]= 901) THEN ([add_val]) ELSE (0) END ) AS v901,
                           ( CASE WHEN ([add_code]= 902) THEN ([add_val]) ELSE (0) END ) AS v902,
                           ( CASE WHEN ([add_code]= 903) THEN ([add_val]) ELSE (0) END ) AS v903,
              FROM add_trans] T

GROUP BY area_code, cycle_no;





Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless.

PBUH
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts
Posted - 2010-06-23 : 05:18:31
1. use ( ) instead of [ ]
2. remove last comma after v903


SELECT
              area_code, cycle_no, sum(v101) AS val101, sum(v102) AS val102, sum(v103) AS val103, sum(v104) AS val104, sum(v105) AS val105,
               sum(v401) AS val401, sum(v901) AS val901, sum(v902) AS val902, sum(v903) AS val903
FROM 
             (SELECT 
                           area_code, cycle_no,
                           ( CASE WHEN ([add_code]= 101) THEN ([add_val]) ELSE (0) END ) AS v101,
                           ( CASE WHEN ([add_code]= 102) THEN ([add_val]) ELSE (0) END ) AS v102,
                           ( CASE WHEN ([add_code]= 103) THEN ([add_val]) ELSE (0) END ) AS v103,
                           ( CASE WHEN ([add_code]= 104) THEN ([add_val]) ELSE (0) END ) AS v104,
                           ( CASE WHEN ([add_code]= 105) THEN ([add_val]) ELSE (0) END ) AS v105,
                           ( CASE WHEN ([add_code]= 401) THEN ([add_val]) ELSE (0) END ) AS v401,
                           ( CASE WHEN ([add_code]= 901) THEN ([add_val]) ELSE (0) END ) AS v901,
                           ( CASE WHEN ([add_code]= 902) THEN ([add_val]) ELSE (0) END ) AS v902,
                           ( CASE WHEN ([add_code]= 903) THEN ([add_val]) ELSE (0) END ) AS v903
              FROM add_trans ) T

GROUP BY area_code, cycle_no;


KH
[spoiler]Time is always against us[/spoiler]
Go to Top of Page

vaibhavktiwari83
Aged Yak Warrior

843 Posts
Posted - 2010-06-23 : 05:18:57
quote:
Originally posted by BrOkEn_iCe

i have error "Unable to parse query text." when i run this query in view

and this error "Msg 102, Level 15, State 1, Line 7
Incorrect syntax near '='.
" when i run it in the query panal


SELECT
              area_code, cycle_no, sum(v101) AS val101, sum(v102) AS val102, sum(v103) AS val103, sum(v104) AS val104, sum(v105) AS val105,
               sum(v401) AS val401, sum(v901) AS val901, sum(v902) AS val902, sum(v903) AS val903
FROM 
             (SELECT 
                           area_code, cycle_no,
                           ( CASE WHEN ([add_code]= 101) THEN ([add_val]) ELSE (0) END ) AS v101,
                           ( CASE WHEN ([add_code]= 102) THEN ([add_val]) ELSE (0) END ) AS v102,
                           ( CASE WHEN ([add_code]= 103) THEN ([add_val]) ELSE (0) END ) AS v103,
                           ( CASE WHEN ([add_code]= 104) THEN ([add_val]) ELSE (0) END ) AS v104,
                           ( CASE WHEN ([add_code]= 105) THEN ([add_val]) ELSE (0) END ) AS v105,
                           ( CASE WHEN ([add_code]= 401) THEN ([add_val]) ELSE (0) END ) AS v401,
                           ( CASE WHEN ([add_code]= 901) THEN ([add_val]) ELSE (0) END ) AS v901,
                           ( CASE WHEN ([add_code]= 902) THEN ([add_val]) ELSE (0) END ) AS v902,
                           ( CASE WHEN ([add_code]= 903) THEN ([add_val]) ELSE (0) END ) AS v903, --remove Comma              FROM add_trans )
T
GROUP BY area_code, cycle_no;



thx


its still has the error
See the red part. that is typo error

Vaibhav T

To walk FAST walk ALONE
To walk FAR walk TOGETHER
Go to Top of Page

BrOkEn_iCe
Starting Member

25 Posts
Posted - 2010-06-23 : 05:31:00
thx for reply but i don't get what u say but i make that change and did't work


SELECT
              area_code, cycle_no, sum(v101) AS val101, sum(v102) AS val102, sum(v103) AS val103, sum(v104) AS val104, sum(v105) AS val105,
               sum(v401) AS val401, sum(v901) AS val901, sum(v902) AS val902, sum(v903) AS val903
FROM 
             [SELECT 
                           area_code,
						   cycle_no,
                           ( CASE WHEN ([add_code]= 101) THEN ([add_val]) ELSE (0) END ) AS v101,
                           ( CASE WHEN ([add_code]= 102) THEN ([add_val]) ELSE (0) END ) AS v102,
                           ( CASE WHEN ([add_code]= 103) THEN ([add_val]) ELSE (0) END ) AS v103,
                           ( CASE WHEN ([add_code]= 104) THEN ([add_val]) ELSE (0) END ) AS v104,
                           ( CASE WHEN ([add_code]= 105) THEN ([add_val]) ELSE (0) END ) AS v105,
                           ( CASE WHEN ([add_code]= 401) THEN ([add_val]) ELSE (0) END ) AS v401,
                           ( CASE WHEN ([add_code]= 901) THEN ([add_val]) ELSE (0) END ) AS v901,
                           ( CASE WHEN ([add_code]= 902) THEN ([add_val]) ELSE (0) END ) AS v902,
                           ( CASE WHEN ([add_code]= 903) THEN ([add_val]) ELSE (0) END ) AS v903,
              FROM add_trans ]. AS [MMM_Alias]

GROUP BY area_code, cycle_no;
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts
Posted - 2010-06-23 : 05:36:04
you are still using bracket [ ]. Change to parenthesis ( )

And also remove the last comma

KH
[spoiler]Time is always against us[/spoiler]
Go to Top of Page

BrOkEn_iCe
Starting Member

25 Posts
Posted - 2010-06-23 : 05:40:34
i made all the change and it still get error but now in the group still didn't wor

thx for reply
Go to Top of Page

BrOkEn_iCe
Starting Member

25 Posts
Posted - 2010-06-23 : 05:42:40
[code]
SELECT
area_code, cycle_no, sum(v101) AS val101, sum(v102) AS val102, sum(v103) AS val103, sum(v104) AS val104, sum(v105) AS val105,
sum(v401) AS val401, sum(v901) AS val901, sum(v902) AS val902, sum(v903) AS val903
FROM
(SELECT
area_code,
cycle_no,
( CASE WHEN ([add_code]= 101) THEN ([add_val]) ELSE (0) END ) AS v101,
( CASE WHEN ([add_code]= 102) THEN ([add_val]) ELSE (0) END ) AS v102,
( CASE WHEN ([add_code]= 103) THEN ([add_val]) ELSE (0) END ) AS v103,
( CASE WHEN ([add_code]= 104) THEN ([add_val]) ELSE (0) END ) AS v104,
( CASE WHEN ([add_code]= 105) THEN ([add_val]) ELSE (0) END ) AS v105,
( CASE WHEN ([add_code]= 401) THEN ([add_val]) ELSE (0) END ) AS v401,
( CASE WHEN ([add_code]= 901) THEN ([add_val]) ELSE (0) END ) AS v901,
( CASE WHEN ([add_code]= 902) THEN ([add_val]) ELSE (0) END ) AS v902,
( CASE WHEN ([add_code]= 903) THEN ([add_val]) ELSE (0) END ) AS v903
FROM add_trans )

GROUP BY area_code, cycle_no;

[/code]


the error "Msg 156, Level 15, State 1, Line 19
Incorrect syntax near the keyword 'GROUP'."
Go to Top of Page

Sachin.Nand

2937 Posts
Posted - 2010-06-23 : 05:46:35
Again you are missing the table alias.

SELECT
              area_code, cycle_no, sum(v101) AS val101, sum(v102) AS val102, sum(v103) AS val103, sum(v104) AS val104, sum(v105) AS val105,
               sum(v401) AS val401, sum(v901) AS val901, sum(v902) AS val902, sum(v903) AS val903
FROM 
             (SELECT 
                           area_code,
						   cycle_no,
                           ( CASE WHEN ([add_code]= 101) THEN ([add_val]) ELSE (0) END ) AS v101,
                           ( CASE WHEN ([add_code]= 102) THEN ([add_val]) ELSE (0) END ) AS v102,
                           ( CASE WHEN ([add_code]= 103) THEN ([add_val]) ELSE (0) END ) AS v103,
                           ( CASE WHEN ([add_code]= 104) THEN ([add_val]) ELSE (0) END ) AS v104,
                           ( CASE WHEN ([add_code]= 105) THEN ([add_val]) ELSE (0) END ) AS v105,
                           ( CASE WHEN ([add_code]= 401) THEN ([add_val]) ELSE (0) END ) AS v401,
                           ( CASE WHEN ([add_code]= 901) THEN ([add_val]) ELSE (0) END ) AS v901,
                           ( CASE WHEN ([add_code]= 902) THEN ([add_val]) ELSE (0) END ) AS v902,
                           ( CASE WHEN ([add_code]= 903) THEN ([add_val]) ELSE (0) END ) AS v903
              FROM add_trans )AS [MMM_Alias]


GROUP BY area_code, cycle_no;




Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless.

PBUH
Go to Top of Page

BrOkEn_iCe
Starting Member

25 Posts
Posted - 2010-06-23 : 05:46:40
thx it work now good have a good day , have a good luck
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts
Posted - 2010-06-23 : 05:46:42
now you missed the table alias

AS [MMM_Alias]


KH
[spoiler]Time is always against us[/spoiler]
Go to Top of Page

BrOkEn_iCe
Starting Member

25 Posts
Posted - 2010-06-23 : 06:17:04
i made it and it work thx very much khtan
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site