I guess I am confused - if you are going to be using SSIS then why would you need to use OPENROWSET to load the data into a table?  SSIS...

You need to specify the admin account that will be used - one that has sysadmin access to that instance of SQL Server.

There is an article that I link to about posting - please review that link.  It shows how to provide sample data that we can utilize to build a working...

I cannot say whether or not those other instances should be removed - it really depends on what they are used for (if they are used) and how you want...

Can you provide sample data and tables that we can use?

BTW - you are not comparing dates.  These are not dates they are strings that may represent some type of...

It appears that someone attempted to perform an upgrade - of some sort.  This could be an version, edition or service pack upgrade that failed.

Since this is a 'backup' server...

If this is a regular requirement - you may want to consider upgrading to SQL Server 2016 (or higher) where you have the new option of using DBCC CLONEDATABASE.

But -...

I am not sure what you are expecting - as these code snippets cannot be optimized, but they can be shortened:

DECLARE @yesterday DATE = dateadd(day, -1, getdate());
EXECUTE...

If the user that owns the agent job is a member of sysadmin - the job will run under the context of the agent service account.  If the job is...

You can wrap the calculation in a CAST or CONVERT:

CAST(SUM(CASE WHEN JobNo = 'Parts' THEN Time1 ELSE 0 END) / SUM(CASE WHEN JobNo NOT IN ('Holiday', 'PTO')...

I would take a step back - and try executing the code in a command/powershell window to test and validate it first.  Then, once you have it working you should...

That would probably work - you need to test it to be sure though.  I prefer not using BETWEEN for date/times - but in this case it might be the...

No hide.

I need the user to be able to make a right click at a db object (table/view), press "Select top 1000 rows" and the SSMS query editor to...

I would not recommend even trying to perform an in-place upgrade.  If it is even possible to upgrade the OS in a cluster - it is going to be an...

The solution will depend on a few different factors.

1. Will the Google Analytics date/time always come first?
2. Could there ever be another entry in the same time frame?

An example check...