My advice - First script will be dropping the server name from the SQL Instance.  So this will NEED to be the one that is stored in your databases.  Since...

One thought on how to create the excel file dynamically would be to have a "template" excel file that has the table headers already entered, but no data and then...

My laptop that I grabbed for cheap came with 6 GB of RAM and a 64GB disk.  Got it new and first thing I did was install the latest windows...

Might be a dumb question but why would you want to install different editions of SQL Server on the same physical machine?

I would recommend having a different folder for each...

A 32GB disk is pretty small for sharing both Windows and SQL Server.  Plus 4 GB of RAM is pretty low for SQL and Windows to play nice.

To install SQL...

Sounds to me like a version issue.  Is your VS2017 project set to use the same SQL Server version as your SSIS server?

Failing that, you can export the ispac file,...

From the article linked in the question:

SQL Server Management Studio uses Microsoft.NET FrameworkSqlClient for execution in regular and SQLCMD mode. When run from the command line, SQLCMD uses the OLE...

I think this information should already be captured in a few tables.  Looking at the table ReportSchedule, joining that back to Schedule, Catalog, and ExecutionLogStorage, you can see the timed...

• This reply was modified 5 years, 9 months ago by Mr. Brian Gale.

I wasn't trying to rag on you Steve.  I was just commenting on the different data types (at least in SQL 2008 R2 which I tested it in) that give...

While I agree with Jeff, it doesn't apply to all larger numbers.  TINYTINT, SMALLINT, and INT's have the same behavior but bigints throw an error instead.

As for the VARCHAR value,...

Can you post more information?

What I expect you are doing is something like:

SELECT *
FROM <TABLE>
WHERE <COLUMN> = 12.3

If that is the case, double check the datatype of...

Hi Jeff,

I sent you a PM on the scripts because I feel we are getting a bit off topic from the original post.  If you prefer, I can post it...

Still not seeing the "recursion" that is required here.  With the updated data, does this not work:

SELECT
[T1].[col11]
, [T1].[col1]
, [T1].[col2]
, [T2].[col5]
, [T2].[col6]
, [T3].[col9]
, [T3].[col2]
 FROMtable1 AS [T1]
 JOINtable2...

Looking at that data set and sample output, I am confused on a few things.  First, why would this need to be dynamic?  Second, why would this need to be...

thanks for the code Jeff.

Downloading it and looking through that today!