EDITED: Yeah, what Lynn said below. That's why I'm the Grasshopper and he's the coach 🙂

That is incredibly helpful! Thank you so much for the time and energy you put into the explanation. I know I'll be visiting this more than once!

ColdCoffee (4/12/2012)

---

THis?

SELECT Male = SUM (S.Male) ,Female = SUM(s.Female) ,Averg = MAX(s.Averg)

FROM

(

SELECT

Male = CASE WHEN Person_Gender = 'Male '...

O.k., here is some test data for the scenario. Thanks again for all the help.

CREATE TABLE Listing

(

Person_IDCHAR(10)NOT NULL,

Program_Version_Code_ListingCHAR(10)NOT NULL,

Entity_Status_ListingVARCHAR(25)NOT NULL,

)

CREATE TABLE Person

(

Person_IDCHAR(10)NOT NULL,

Person_GenderCHAR(10)NOT NULL,

Birth_Date_StudentDATENOT NULL,

)

INSERT INTO Listing

(

Person_ID,

Program_Version_Code_Listing,

Entity_Status_Listing

)

VALUES

(234543, 'AR-2016', 'Accept'),

(846468, 'AR-2016',...

Sure thing. Give me a little to create...

That is what I want to do, I'm just...

Thanks for the reply. I see three books that are closely related:

Teo Lachev

http://www.amazon.com/Applied-Microsoft-Server-Reporting-Services/dp/0976635313

Paul Turley

http://www.amazon.com/Microsoft-Server-Reporting-Services-Recipes/dp/0470563117/ref=pd_bxgy_b_text_c

Brian Larsen

http://www.amazon.com/Microsoft-Server-2008-Reporting-Services/dp/0071548084/ref=pd_bxgy_b_text_b

I was thinking of starting with Larsen since it has the best reviews. Any thoughts on...

As I was saying... 🙂

Thanks so much for the help. I'll get...

One more question on this. My row_number doesn't seem to be working in a few instances. Here's what I have:

WITH cte AS

(

SELECT

'CVPA~SIS~AD~Ad_Exam~' + CAST(Ad_Exam.Admission_Exam_ID AS NVARCHAR) AS PKEY_CVPA_SIS_AD_Admission_Exam ...

Thanks to everyone for the help!!

Lutz,

Yes, I was working through the replies in order. You nailed it! I know you're probably busy, but would you mind explaining how it works? I don't understand 'WITH cte...

Thanks for the reply. The results should be something like this: (I apologize for the format - I can't for the life of me figure how to make it look...

O.k., I've been working on this. I've created a test scenario below. I really apologize if it's helpful or too much, but I thought it might give the clearest explanation...

Thanks, Lutz. I think I understand - One result set per Student_ID as long as the other rows match in every column except AP_Ex.Ap_Expt_Date. If you don't mind another question...

Thanks for your reply. Can I only get a good result set if I take all of the other fields out of the select query? Those contain information I'm going...