July 6, 2009 at 10:00 am
Everyday, I have to compare two columns of couple tables. after the comparison, i would need a way to update some of the rows.
what is the easiest way to pull the data for compare and write back selected rows to database?
are there good samples in this area?
thanks.
July 6, 2009 at 10:38 am
I am pretty sure you cannot do that with Reporting Services, I'm guessing you will have to build an App to do that..
CEWII
July 6, 2009 at 10:41 am
You may find it easier to use some T-SQL to perform this task as i am sure it is not possible using Reporting services, also there are a number of third-party products that have data compare products that will automate the process for you..
July 10, 2009 at 6:59 am
You can put inserts and updates in your dataset stored proc.
July 11, 2009 at 8:52 am
Robert Bruckner has some examples of how to go about this:
The Pace is Glacial (Hangman Report)
Multi-Player Gaming in RS (aka BI Power Hour 2008)
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply