469,138 Members | 1,298 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,138 developers. It's quick & easy.

help with sql server select statement

i am trting to count how many people answered yes in question cause i am running questionniare for my company using sql with .net

Select COUNT (*) as Q7 FROM IOLS_Quest1 WHERE Q7 = 'Yes'

error massage Msg 102, Level 15, State 1, Line 11
Incorrect syntax near 'IOLS_Quest1'.
Mar 12 '08 #1
2 926
davidson1
144 100+
Try this

Select COUNT (*) FROM IOLS_Quest1 WHERE Q7 = 'Yes'

Davidson
Mar 12 '08 #2
i am trting to count how many people answered yes in question cause i am running questionniare for my company using sql with .net

Select COUNT (*) as Q7 FROM IOLS_Quest1 WHERE Q7 = 'Yes'

error massage Msg 102, Level 15, State 1, Line 11
Incorrect syntax near 'IOLS_Quest1'.
The statement you entered here looks sufficiently correct, but I'm assuming you retyped it, because the word "message" is incorrectly spelled here, and the error message refers to Line 11 in your code. Can you copy and paste the actual code that is sent to the SQL server?
Mar 13 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

28 posts views Thread by stu_gots | last post: by
8 posts views Thread by db2sysc | last post: by
6 posts views Thread by Twobridge | last post: by
15 posts views Thread by Jay | last post: by
6 posts views Thread by zaina | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.