Sql query(Distict and count)

Question

0.00/5 (No votes)

See more:

I want to fetch dishes name with count their quantity b/two dates. this is my code--

SELECT COUNT(Qty) FROM (SELECT Dishes FROM Temp_Dishes where Dates='" + dd.ToString("dd-MM-yyyy") + "' GROUP BY Dishes) p

the error msg is-"No value given for one or more required parameters."

Posted 10-Oct-13 22:32pm

Jyoti Pandey

Add a Solution

Comments

thatraja 11-Oct-13 4:57am

Your query is wrong, include the table srtuctures & sample data in your question.

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

seyed mahmud shahrokni · Answer 1 · 2013-10-10T22:40:00

Solution 1

You've mentioned your tables ,
but i think , you should fetch Qty in your inner query , if you want to count the qty field
you should fetch it in the inner query !

Posted 10-Oct-13 22:40pm

seyed mahmud shahrokni

Comments

Aniket Yadav 11-Oct-13 5:02am

Provide Sample data.

ArunRajendra · Answer 2 · 2013-10-10T23:02:00

Solution 2

Try the query similar to this. Hope it helps.

SQL

SELECT Dishes,SUM(qty) FROM Temp_Dishes where Dates between @startdate and @enddate GROUP BY Dishes

Posted 10-Oct-13 23:02pm

ArunRajendra

Updated 10-Oct-13 23:59pm

v2

Comments

Jyoti Pandey 12-Oct-13 2:32am

Thanks,its working now...!!

ArunRajendra 16-Oct-13 23:49pm

Hi, Please mark the solution as answered so that it will help other in future. Rate the answer if you want to where 5 being the highest.

Thanks
Arun

Aarti Meswania · Answer 3 · 2013-10-10T23:20:00

Solution 3

instead of

C#

dd.ToString("dd-MM-yyyy")

write

C#

dd.ToString("yyyy-MM-dd")

Happy Coding!
:)

Posted 10-Oct-13 23:20pm

Aarti Meswania

V. · Answer 4 · 2013-10-11T01:30:00

There are a few things wrong here.

1.
First, if you can, use parametrized queries instead of concatenating strings

2.
this part:

C#

Dates='" + dd.ToString("dd-MM-yyyy")

is not guaranteed to work. Or pass a date object through parametrized queries or parse the date of the column to a string with the same format you pass the dd value. In this case dd-MM-yyyy.

3.
I'm not sure you need an inner and outer query and I don't believe this will work. The outer query does not know "Qty".
Doesn't this work?

C#

SELECT Count(Dishes) as qty FROM Temp_Dishes where Dates=@startdate GROUP BY Dishes

Hope this helps.

Sql query(Distict and count)

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us