Thanks for the information. It sounds like groups are the way to go even if at the time it only ends up being one person.

Steve - Thanks for the reply. There is a ton of helpful information in those search results. I should be able to piece enough together to make it work. Can...

SQL Server won't be doing the decompressing. I'm trying to use a third party utility that needs the backups to be decompressed.

I finally figured out what the issue was. I found that in the rsreportserver.config file this line existed

<Extension Name="ATOM" Type="Microsoft.ReportingServices.Rendering.DataRenderer.AtomDataReport,Microsoft.ReportingServices.DataRendering" Visible="False"/>

I had to update it to

            
June 20, 2019 at 5:34 pm
            
#3655868

            
            
                                                
        

There will some data manipulation to create matrices, charts, etc. From what I've read this can act as a source in Excel. The SSRS output will mirror the Excel version.

So in my hypothetical scenario, is my only option to find data changes to load the file and compare it to the previous day's table using the ID for all...

I called it a daily file in my hypothetical scenario of one that has the same structure of the tables. Sorry if that was not clear or got lost in...

I understand the concept but not how it applies to the situation I'm working with. Suppose today I create a new target table with the VersionCol field you explained above...

Phrasing my question a little better after thinking about RowVersion or adding my own data added field, wouldn't I still have to load the file to SQL, compare the source...

Phil - From what I'm reading about RowVersion, that could be a potential solution going forward but won't help looking back at all of the archived tables to determine if...

A last updated field would be too convenient so naturally this doesn't have one. I'm able to make the assumption that a large majority of records are inactive solely based...

Jeff - How to do you suggest I add the total of all monthly averages to the result below

;

WITH AggCTE
AS (
SELECT DATENAME(mm, DateEntered) AS MonthChar
,Sales
FROM table1
)
SELECT *
FROM...

Thom - Yes, each cell is an average of the set it's based on. I totally agree it's a strange way to see a yearly average but that's how the...

That's what I'm doing but it isn't coming back with the amount of 10,466,457 which is the sum of the average per month. The result of that formula is a...

When I do that I get the sum of all sales instead of the sum of the average sales for each month. I keep going back to starting with this...