Update query to get results as count

I have a MS SQL Query on a web page -

SELECT [login to view URL], [login to view URL], QuestionOptions.[option]

FROM SurveyResponse INNER JOIN

QuestionOptions ON [login to view URL] = [login to view URL]

WHERE ([login to view URL] = 11)

SurveyResponse is a table with thousands of users response to questions

QuestionOptions is a table with the available responses to the questions.

I need the query updated so that I get just a count of how many of each option available is in the query - not the full list of all several thousand results. - need to keep the questionid so we only have one question at a time

Evner: Microsoft SQL Server, SQL

Se mere: php script display query results, show query results website, oracle include column headers query results, count number of rows in sql query result php, count number of rows in sql query result c#, count number of rows in sql query result, count number of rows in sql query result oracle, count number of rows in sql query result java, how to get count 0 in sql query, count number of rows in mysql query result, count number of columns in sql query result, gridview displaying search results count, google map mysql query results, extract results count google, php displaying query results, count time continuously mfc, count time project igoogle, create browser game java count time, php count time script browser game, access query count time periods examples date

Om arbejdsgiveren:
( 426 bedømmelser ) Davenport, United States

Projekt ID: #18931899

Tildelt til:


Hello, As an expert in ms sql server, i am very much interested to fix this query. I can do it quickly and available now to do it. Thanks

$19 USD in 0 dage
(210 bedømmelser)

6 freelancere byder i gennemsnit $22 på dette job


Hi, I have 9 years experience in development and deployment that includes SQL Server, SSRS, SSIS and .NET. Involved in SQL Server activities like Installing, Migrations, Table Partitioning, Configuring maintenanc Flere

$25 USD på 1 dag
(47 bedømmelser)

Please message me. Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 9.2 years experience in MS SQL Server and 6.4 years experience in SSRS, SSIS (Import / Export). Please let me Flere

$24 USD in 0 dage
(22 bedømmelser)

Hi Boss! I will available full time for this project and available until you satisfied with work,As a senior developer who has more than 5 years of experience in .NET Development,i believe my abilities would be perfec Flere

$25 USD in 0 dage
(0 bedømmelser)

Hi I would be happy to work with you I have experience in MySQL and other databases I am waiting for your message to help you. thank yo

$15 USD på 1 dag
(0 bedømmelser)

Hello, How are you? I am strongest SQL expert. I have experience to develop several websites for 4+ years. If you have any issue, I will solve it quickly. Please reply me. Thank you.

$25 USD på 1 dag
(0 bedømmelser)