Attached is an export of the table into an excel spreadsheet.

For report week Mar 24th, the [13MTTR-W] is the average of [MTTR-W] for the weeks Mar 24th up...

That works great. I only have 1 change. I need the average of the sum of the 'critical' & 'high' records.

Thank you!! I'll test this out, and get back with you!!

I've tried using SQL Server 2014, but it will not work with the 2008 DB. I'm stuck in the middle.

I'm trying this using SQL Server 2008. The DB is an SQL 2008 DB. The version of SQL Server 2012 I have is the express version. I'm unable to create...

I forgot to write, when I test the preview, it displays the data records. When I create the SSIS rather than run immediately, it still imports 0 records.

In the steps of creating an SSIS package, I'm running the query immediately to confirm everything is working properly, and it's not.

When I parse the query, it...

Yes, I'm making sure that I'm running the query to insert the records into the proper table. I have approximately 20 queries that go into 20 tables, and the problem...

Thanks for replying.

Here's an example of a query. I used the term example because the problem occurs with every query.
[
use DemandManagement

SELECT

I've been using an Access DB that consists of a front end DB and a back end DB. I've upsized the back end to SQL.

Previously, I would import an Excel...

Thanks for the reply.

I should have written I'm importing Excel spreadsheets on a weekly and monthly basis. I'm hoping their is some other way than using SQL import/Export wizard.

I haven't tried any other methods of deleting the records. I figured this would be a quick method, and I'm stuck here.

I'll also try a pass through query.

One other question,...

Wendell, thank you for the detailed response.

I've kinda been taking that approach. I've upsized the back end to SQL. Everything I've read is exactly what you've written. All of my...