help with sql server select statement

[zibuyilek]

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'.

[davidson1]

Try this

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

Davidson

[FredSovenix]

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?