Thanks to you BOTH for taking the time posting the code, lot to digest...

I just have a  question, would it be possible to also include a row total for each...

Okay so I keep the same Table and followed these steps on my DEV Box...

Dropped FK's

Deleted old PK

Added new suggested Indexes

Re-Applied Fk's

Testing

Thx.

Thanks, the output will have Entity going across the top of the email, and rows will be the Description, and it's associated totalamt. Then at the bottom of the email...

I think that's what I tried in an earlier post but had an error can you take a look ..

Thanks.

I'll try that today Scott... Thanks.

Will I still be able to create the totals\Grand at the Description and Entity levels.

It's derived from the Quality_Datetime that's already defined in the Table. When records are Inserted that's when Quality_Date

is populated.. I can't change how that works.

Thanks.

As I started down the path of re-clustering the PK.

UNIQUEly CLUSTERED on ( Quality_Date, Quality_ID ).

Quality_Date is a computed column and set to NULL  which can't be part of the...

I do the preagg then the crosstab and finally dynamic column for Entity, but when I do the Execute(SQL) it throws an

error that I can't seem to figure out. I...

I've been trying to find the thread that has your examples..

The email will be an embedded table..

Insert Into frt_tracker

Values('240','Frt','2200')

Insert Into frt_tracker

Values('240','Acc','200')

Insert Into frt_tracker

Values('440','Brd','20')

Report Example:

240        440

Frt                         ...

I'm going to re-cluster in TEST to see what effect it has on processing...

Thanks.,

Thanks that worked.

To process this data I setup Sql Agent jobs and basically setup one for each oven\wireline. It's processing the queue of records fairly fast but I do see a WAIT...

I changed both queries to use the Not Exists, and so far looks promising in the performance category.  I have a archive process setup

to keep both Quality,the Detail and Atrribute...