Update query to get results as count

$10-30 USD

Completed

Posted

about 5 years ago

$10-30 USD

Paid on delivery

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

Microsoft SQL Server

SQL

Project ID: 18931899

About the project

6 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

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 day

5.0

(210 reviews)

7.4

6 freelancers are bidding on average $22 USD 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 maintenance jobs, Optimizing etc. I have expertise in writing complex queries with proper joins and index selection. Involved in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, Triggers, functions and views. Thanks

$25 USD in 1 day

4.8

(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 know more details and when we will start. Sky pe jikenjd

$24 USD in 0 day

5.0

(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 perfect for your venture and i'd like to help you with this project Please feel free to discuss with me. best regards

$25 USD in 0 day

0.0

(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.0

(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