Best way to load data

[#1]

Hello,

I have two databases in sqlserver that have same tables with same column names and structure. One of them has data prior 90 days from today and the other has data from last 90 days. I have a sql query that runs against both databases to fetch data for a report for the past 2 years and it performs an inner join and both the tables have millions of rows.

With a single OLEDB connection I wont be able to run that query in Qlikview if i need to generate a report for the past 2 years.

I am trying to figure out what is best way to run the query from performance perspective?

[simonb2013]

Sasi,

Give us a better picture of what you are doing.

Are you working in Sql Server Management Studio ?

Give us the exact code you are trying.

Give us the exact error messages you are receiving.

Screen shots if possible.