Completed

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

Skills: Microsoft SQL Server, SQL

See more: 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

About the Employer:
( 426 reviews ) Davenport, United States

Project ID: #18931899

Awarded to:

sumon355

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 days
(210 Reviews)
7.4

6 freelancers are bidding on average $22 for this job

feninsoftech

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 More

$25 USD in 1 day
(47 Reviews)
6.5
vw7590795vw

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 More

$24 USD in 0 days
(22 Reviews)
4.1
yoyo09

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 More

$25 USD in 0 days
(0 Reviews)
0.0
hadramisouedi

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 in 1 day
(0 Reviews)
0.0
MariaDean1

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 in 1 day
(0 Reviews)
0.0