DaniWeb Forum Index > Web Development > Databases > MS SQL

Use Count criteria as row header

Please support our MS SQL advertiser: Intel Parallel Studio Home

Thread Solved

•

•

Join Date: Sep 2008

Posts: 16

Reputation: spinnaret is an unknown quantity at this point

spinnaret is an unknown quantity at this point

Solved Threads: 1

spinnaret is offline

Offline

Newbie Poster

Use Count criteria as row header

0

#1

Oct 1st, 2008

I need to write a stored procedure to analyse appointments for the last 12 months.

I need to get each salesperson (by ID) and for each person carry out a count of the number of appointments and count them by outcome (sale, second meeting , failure etc.) and then display them with
Salesperson, Count Sale, Count 2nd Meeting, Count Failure

Any one got any code snippets for this?

Reply With Quote

Quick reply to this message

•

•

Join Date: Sep 2008

Posts: 16

Reputation: spinnaret is an unknown quantity at this point

spinnaret is an unknown quantity at this point

Solved Threads: 1

spinnaret is offline

Offline

Newbie Poster

Re: Use Count criteria as row header

0

#2

Oct 2nd, 2008

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
                SELECT 		Salesperson,
		SUM(CASE WHEN Outcome = '0' THEN 1 ELSE 0 END) AS Outcome0,
		SUM(CASE WHEN Outcome = '1' THEN 1 ELSE 0 END) AS Outcome1,
 		SUM(CASE WHEN Outcome = '2' THEN 1 ELSE 0 END) AS Outcome2,
     		SUM(CASE WHEN Outcome = '3' THEN 1 ELSE 0 END) AS Outcome3,
		SUM(CASE WHEN Outcome = '4' THEN 1 ELSE 0 END) AS Outcome4,
     		SUM(CASE WHEN Outcome = '18' THEN 1 ELSE 0 END) AS Outcome18
FROM		Schedules
WHERE 		IndustryDivision = 10
                SELECT 		Salesperson,
		SUM(CASE WHEN Outcome = '0' THEN 1 ELSE 0 END) as Outcome0,
		SUM(CASE WHEN Outcome = '1' THEN 1 ELSE 0 END) as Outcome1,
 		SUM(CASE WHEN Outcome = '2' THEN 1 ELSE 0 END) as Outcome2,
     		SUM(CASE WHEN Outcome = '3' THEN 1 ELSE 0 END) as Outcome3,
		SUM(CASE WHEN Outcome = '4' THEN 1 ELSE 0 END) as Outcome4,
     		SUM(CASE WHEN Outcome = '18' THEN 1 ELSE 0 END) as Outcome18
FROM		Schedules
WHERE 		IndustryDivision = 10

Reply With Quote

Quick reply to this message

Reply

Quick Reply to Thread

Show Printable Version

Similar Threads

I've got Trojan.Holax... is this bad? (Viruses, Spyware and other Nasties)
not-a-virusadware (Viruses, Spyware and other Nasties)

Other Threads in the MS SQL Forum

Previous Thread: display all the records in table in SQL using VBScript in ASP
Next Thread: Pagination confusion

Thread Tools	Search this Thread
Show Printable Version Email this Page

About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy |