Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Windza
Yak Posting Veteran
61 Posts |
 Posted - 2009-07-26 : 23:57:09
|
| Can anyone offer some advice with regard to setting up a report that generates on a time schedule and reports only information that has been altered or added since the previous generation?I'm assuming some sort of snapshot would need to be generated and deducted from the next run - the only problem is I have no idea where to start with this - Can this type of functionality be achieved within SQL Server 2008?I've looked into the Report Server side of things, but can't locate settings that might be relevant - does it need to be query based?Sorry if I seem a little vague but it's difficult to ask the right questions without knowing where to start...Any help is appreciated, Regards... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-30 : 14:19:52
|
| you can achieve this provided you've an audit column in your table |
 |
|
|
Windza
Yak Posting Veteran
61 Posts |
Posted - 2009-08-16 : 21:41:33
|
| Thanks Vis... you've given me something more to learn about SQL :-) |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-08-17 : 07:40:58
|
| welcome |
|
|
|
|
|
|
How To: Report data changes within a set period?