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...

That gets me closer. However, this report also needs to do yearly comparisons where it will look at the same month a year ago so the T-SQL  might get cumbersome....

That did it. Thanks!

Michael - I'm fairly new to SSRS so I'm not sure what you mean by that. In Reporting Services Configuration Manager --> Database --> Current Report Server Database Credential I...

Thanks, Jeff. That's probably best anyway so that I can draw their attention to it as it happens since a lot of times they don't realize what the size will...

Steve - Are you saying you were able to add fixed header rows after exporting to Excel by using a matrix or are you saying you were able to freeze...

I was thinking of some kind of exceptions list that would allow certain tables to grow over the limit. However, my original post looking for a way to limit the...

Thanks for all of the advice. It sounds like I need to change the way our processes are currently handled.

Thanks. I kind of like the idea of disabling the job and having the proc start the job when it finishes. Like I said, I'm new to SSRS so I'm...