I hope that you can help me with this question, I am working on a multi servers (DB2 and SQL). The stored procedure will pull data from server A, then look up value from server B through Left Outer Join.
The problem is DBA only allowing to use this EXEC dbo.spGetStaffing '01/01/2015', '07/01/2015' only, so no CREATE/INSERT/TRUNCATE, only the SELECT statement. Attach is the DataStage job, It's easy through SSIS or datastage but as Analyst, I need to testing and I am frustrated on how to use the data from Store procedure
Thank you so much!