You guys are Awesome!! Thanks for the suggestions, I will re work my stored procedure this way and use this technique going forward.

I really appreciate the help!!:cool:

18 records (One entry form each month going back 18 months).

Ok, I have seen some samples of this method. But do you know a better way for me to approach this other than using Dynamic SQL?

Here's how some of the output looks...

Query1

ATTUID ...

Some of them do, I'm ok with the ones that come out null. But the ones that are supposed to have values are coming out with zeros. That's...

You are awesome!!!

Thanks for your help:cool:

This is great, and I have long considered normalizing this table. I inherit this data from another system that isn't normalized, actually it's coming in from a spreadsheet.

But I...

Ok, table structure looks like this.

CREATE TABLE [tbl_CDE_Hierarchy_Export] (

[Load Date] [smalldatetime] NULL ,

[Percent_Elapsed_Days] [float] NULL ,

[Level] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[Title] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[ATTUID] [nvarchar] (10)...

Thank you so much!!!!

That's exactly what I needed.

😎

Thank you for your advice regarding this Data Modeling Exercise that I’m having to do. After considering your post, I have further re-designed my table structure to look like...

I wanted to take the time to thank you all for you extensive help in reconstructing my mess of a Stored Procedure. I have done the first phase of...

Once I restructure the Hierarchy table and take all of the redundant Crap out I think it will be a lot less than 60k records. Because not all of...

There are 60k available reps in the database. There's going to be 60k times 8 records in the database.

I had originally planned on Creating a base query that would pull all 60k potential reps from the Hierarchy table (Once I get it Re-built), this query would be based...

Not exactly. With this problem, I have to give the user access to choose an employee that belongs to the data record from a pool of 60k available employees...