I have a dataset that is running a very simple query, pulling an OrderID field based on the TransactionID parameter (User Input).
This dataset is pointed to Database_A.
SELECT OrderID FROM Orders WITH (NOLOCK) WHERE OrderID = @TransactionID
Now, this query above might return one of more records.
I need to query another system (Database_B) using the results from this query. I need to store the OrderIDs that I got somewhere and check them against another system and display the results on my report.
Please note - Database_B is located on a totally different server.
Can you guys think of a way of doing this?
I'm using SSRS 2008, not 2008 R2.
View Complete Post