none
Using SQL results as parameters for Oracle query RRS feed

  • Question

  • Hi, I currently have a table.  This table A contains 2 columns.  Column A = cell_number and Column B = account_number.  this table A is located in sql server.  I want to use the columns A & B as parameters and pass them into a table B located in oracle.  However, table B has over 100 million records. 

    this is how i started my query..however...this will perform the openquery first and then the inner join, which I want to avoid....

    select b.*
    
    from business_analysis.dbo.tableA as a
    
    inner join ( select *
    			from openquery(oracle_db,'
    							select b.ban
    							,b.subscriber_no
    							,b.soc
    							,b.soc_seq_no
    							,b.effective_date
    							,b.expiration_date
    							,b.effective_issue_date transaction_date
    							from ods.tableB b
    							')
    			)b
    on a.accountnumber = b.ban
    and a.fidonumber = b.subscriber_no
    
    Thank you !
    • Moved by Mr. WhartyModerator Wednesday, June 6, 2012 1:03 PM Off Topic (From:SQL Server Samples and Community Projects)
    Monday, January 17, 2011 5:19 PM