Thanks guys, I appreciate your help

This is what bopeavy was asking for. Dixie, I agree with you, from now on, I will comply with the rules.

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE AggregateTable(

[Rep] [nvarchar](255)...

Thanks Dixie. I will take that into consideration next time I post a question. I will try your solution and see if it helps.

Hi Dixie,

The fields you see are just aliases and not the actual field names in the table

Thank you bopeavy.

My structure is like this,

[REP] [# of Audits] ...