DiabloZA (7/27/2014)
The idea is that even though I'm looking back to current Monday if the week, I don't want to pick a record again once I have already looked at it.I hope I explained it alright but please ask me if you have questions and than you in advance for helping.
I recently dealt with an issue like this, but I want to ask a few questions before I can help you, otherwise it's real easy to shoot yourself in the foot.
What is the delivery mechanism for this report? What are the expectations if the report is run, is not saved in some way by the user (or it fails), and they cannot recover the data from the source system without an operations ticket to adjust data in the production system?
You only want to do reports that change the source data during the run period via an automated component that will save off the report for the end users, who can then use it at their leisure. Trusting Windows to correctly save to Excel 100% of the time on the first report run, or for someone's IE not to crash before the results get to screen (but the procs complete) is setting yourself up for a serious problem.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA