Suoritettu

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

Taidot: Microsoft SQL Server, SQL

Näytä lisää: 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

Tietoa työnantajasta:
( 426 arvostelua ) Davenport, United States

Projektin tunnus: #18931899

Myönnetty käyttäjälle:

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 0 päivässä
(210 Arvostelua)
7.4

6 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 Lisää

$25 USD 1 päivässä
(47 arvostelua)
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 Lisää

$24 USD 0 päivässä
(22 arvostelua)
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 Lisää

$25 USD 0 päivässä
(0 arvostelua)
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 1 päivässä
(0 arvostelua)
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 1 päivässä
(0 arvostelua)
0.0