WHERE LEFT(AKey, 3) IN ('AAA', 'BBB', 'CCC', 'DDD', 'EEE', 'GGG', 'JJJ') AND LEN(AKey) = 9

This is a display/report issue - it can and should be done in the report and not in SQL Server.  Your example does not include all of the data elements...

You are welcome

so - hold on - are you guys saying that I should put every Saturday and sunday into my holidays table?  that kinda makes sense.....

all I have to do...

so - hold on - are you guys saying that I should put every Saturday and sunday into my holidays table?  that kinda makes sense.....

all I have to do...

so - hold on - are you guys saying that I should put every Saturday and sunday into my holidays table?  that kinda makes sense.....

all I have to do...

Please note: there are 2 check boxes on that page:

Limit size of job history log - if this is checked, SQL Server will automatically manage the size of the job...

Did you stop the transaction log backups on the primary for those 2 databases?  If not - most likely one or more transaction log backups have occurred since you started...

You should be able to place the file(s) in the ..\Data folder under the instance in C:\Program Files\.  If you cannot put the files in that location then you need...

Script the statement and execute it from a query window instead of the GUI.  This will avoid the timeout error - but I am guessing based on your other question...

This should get you started

Declare @database sysname = '{your database}';

Declare @backup_set_id_start int 
      , @backup_last_lsn numeric(25,0);

 --==== Get Backup Set for this...

If the vendor wants to see a full sample rate - you can set the NO_RECOMPUTE flag on those stats so they will not be auto updated.  If you do...

A few years ago, I did a similar upgrade (2008 R2 to 2014 parallel upgrade).  One thing you will want to watch out for:

Queries that use table valued functions...

I hadn't read the information about the source table being on another database. A good way to go is to first copy the data onto a Staging table on...

Thanks Jeffrey. One question: why even have step 2 ? Cant you just have the stored procedure get data from original source ? If a network error occurs, a...