Hi All,
i had to do couple of things to fix this issue
   1) i removed fragmentation on my most active table. i rebuild the indexes with FILL Factor...

i really appreciate your guys time and effort, i implemented a hybrid solution based on the Scott and Sergy ideas and it worked execution times have dropped from 1.2 Sec...

Thank you so much.. Appreciate your response

Hey Erin,

this is an access report, where the client has the front GUI, i am populating the back end data tables

is there way, i could populate my data into excel...

we thought about implementing this report in SSIS, but we are dealing with 24 months worth of sales data, as well quarterly and yearly data, i have dynamically changing columns

For...

Hi Erin, Client requirement is to have a report in push off a button.. using ODBC Linked Tables is more of a manual process.. let me know your thoughts on...