Thank you! An alternative that may work double duty for some other things I do might be to have a 4th field that flags the children when I build...

Thanks Luis. Appreciate that tip. Will do.

I also found I could get the same result doing this. Not sure which is best, could cause an anomaly, or if...

With this great help I got brave and added a needed LEFT OUTER JOIN. I need to pull in a field from another table. Had some trouble, got...

Sweet. I moved the plan date conditional to the beginning, and had a little trouble with the plus sign normally at the end of the THEN line but I...

Great, thank you. What I have is working great.

Last thing to make this golden. All of my milestones have Forecast and Actual. But I have a handful...

Any way to tell where I'm getting this warning from:

Warning: Null value is eliminated by an aggregate or other SET operation.

Luis: Thanks. Yes a create a new table every time is what I need. I take a daily push and turn it into this new table.

EDIT: Nevermind, I figured it the select into. Thanks again!

Luis, thank you. I'm still studying the dynamic code, to understand it. Great learning experience, I really appreciate you posting it.

It appears it will be a whole lot...

Not so easy for me LOL. But I'm getting better by the hour.

I figured it out, I...

OK, works just as I needed, thank you.

I actually have hundreds of milestone names in the real table. But I'm only wanting to pull a specific set...

Thanks guys, by the time I had written up the creation of a sample table you beat me to the how to's.

SQL Server is pretty new to me,...

The real tables I'm working with are monsters and have proprietary data. I'll try to build some sample tables to demonstrate.

Thanks

Edit: I realized I don't know how to...

So I got close to getting this to work, but still having one last problem...

If I place the excel file literally ON the Windows Server that SQL server is installed...

Thank you. I figured it out and got past the errors once I figured out it was looking for the Excel file from the perspective of the SQL server,...