Thank you both.  Good advice.  I tried the database diagram and it is very useful.  I'm also starting to look at any documentation inside of the stored procedure, functions and...

Thank Jeff!

Using the text mode for
PRINT @ColumnsForCREATE;
PRINT @ColumnsForSELECT;
It clearly showed me that I was missing the schema.  It now runs perfectly in the dev...

I managed to get the pivot to work for the columns, but the order by is not working that places the columns in the correct order. Next I need to...

I like the refreshable spreadsheet and it's what the business wants instead of say 10 excel spreadsheets we have one that refreshes with the new column names for the report. ...

Hello Jeff,

This is my first time out of the gate with SQL Server Central. Thanks for the tips and advice.

You are correct: I would like the...

Correction on Table2:

Create Table2(

[t2_Name] [varchar] (30) NULL,

December 5, 2017 at 5:53 pm