Drew,

Thank You so much.

I resolved it by adding new columns.

Drew,

I understand.

One last question from my side.

Do you want me to add new columns to my trg?

Am asking this becuase we dont have any permissions to add those new...

In the above scenario, if u can hold the district count, then it would solve the problem.

Please correct me if am wrong.

Drew,

I need this help from you.

It is urgent!!!

Thanks in advance.

Drew,

Here is what i actual want!!!!

Am not getting how to achieve this dynamically.

I need your help!

The reason why i am stressing to get the src record count is,i have...

Now my ddl / dml will be as follows

DROP TABLE #test

create table #test

( yr int,

dist varchar(10),

school varchar(10),

history int,

science int,

commerce int

)

GO

insert #test(yr,dist,school,history,science,commerce) values(1991,'D1','S1','100','400',null)

insert #test(yr,dist,school,history,science,commerce) values(1991,'D1','S1','300','504','305')

insert #test(yr,dist,school,history,science,commerce) values(1991,'D1','S1','358','650',null)

insert #test(yr,dist,school,history,science,commerce) values(1992,'D1','S1','100','400',null)

insert...

Why i am asking because suppose if i have multiple years data and i want to show the report as follows then,

how can i do that.

Assuming my final data in...

i.e . irrespective of district and school. i need the overall students attended for the exam. From source file,it is clear we are having 3 records. Right? that i need...

Hi Drew,

You are right on. using this method we can get the correct averages.

Now we are placed with final output as below. Right?

Using the below output, how can i get...

Hi Arun,

Thank You.:-)

Hi Frank,

You are right on!

I have done the same thing yesterday!

SUM(T.STUDENT_COUNT*CONVERT(Decimal(9,2),SCORE))/SUM(T.STUDENT_COUNT) As AvgScore

The thing is, the nature of the client data is like that.

Thank You All.

Hi Miller,

Thanks for the input. Thanks for the CTE. Am still working for the work around.

As you said, both the averages are correct in differenct circumstances but the thing is,...

Hi Arun,

I have put up some meaningful data for you.

CREATE TABLE ExcelData

(yr int,

CollegeName varchar(20),

race varchar(20),

gender varchar(20),

history varchar(10),

science varchar(10),

commerce varchar(10)

)

insert into ExcelData

select...

Thanks Dude! 🙂

Thanks Dude!

It solved my problem.