Big Sql Server Query

Question

0.00/5 (No votes)

See more:

Hi guys i have a big table and i want to get some data from it
table name productivity Content this columns
Date1,ACC_NO,Balance,Collector,Call_Visit,Trials,PTP_Type,PTP_Amount,Kept_Amount
How i want to get Acc_No , Total Balance, Count Collectors Without Repeat data,Call_Visit Without Repeat Data
count Trials without repeat data, Count PTP_Type without repeat data, Count PTP_Amount without repeat data, Count Kept_Amount Without repeat data
Sum total Kept_Amount With data that hide
that meaing i want to get sum some data that i want it to be repat
this a ex file in excel:
set date = 01/08/2013
i have 6 rows that have
3 [Collectors] => Count
6 [Acc_No] => Count
480104 Total [Balance] => SUM
2 [Call_Visit] => Count
6 [Trials] => Count
1 [PTP_Type] => Count
1 [PTP_Amount] => Count
9000 [PTP_Amount] => SUM
That result that i want
when [date] be 01/08/2013 and [Agency] = abo shady

This Excel Link:
ivity.xls">https://www.dropbox.com/s/dmfmz3eh9mfi54w/productivity.xls[^]
I want this code so fast
Thanks Guys

Posted 5-Nov-13 13:16pm

Ahmed Emad

Add a Solution

Comments

ZurdoDev 5-Nov-13 20:28pm

Do you have a question?

Ahmed Emad 6-Nov-13 3:10am

Yes
I want to sum all column value (get total)
And get count for cell s without duplicate cells but calculate it in sum total
In one query

ZurdoDev 6-Nov-13 7:21am

So, where are you stuck?

Ahmed Emad 6-Nov-13 8:19am

https://db.tt/JYjTozYY
This excel example
Try to filter date as 01/08/2013
You I want to get collectors count without duplicate not so I get 6 when I write COUNT (Collector) but they 3 collectors

ZurdoDev 6-Nov-13 8:22am

I don't understand.

Ahmed Emad 6-Nov-13 8:59am

Say
I have 3 collectors in collector column {ahmed, mohamed, ahmed}
And I have balance columns content {1000, 500, 400}
So I want to get collectors count that is 2 collector {ahmed, mohamed}
And get sum balance that must be 1900

ZurdoDev 6-Nov-13 9:29am

So you can use SUM(balance) to get the total balance. Then you need to do a derived table likely and use DISTINCT and then on the outside use COUNT(). Something along those lines.

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)