Hi Folks,

I am having a requirement of joining a Flat file wich is on the Reporting Server with SQL Table.Users are not willing to Join the Flat File with SQL Table Directly as it will result in Perfomance Issue.Moreover the Users are restricted to Info Assist GUI only they Don't have the Access to Text Editor.Is there any way i can create a Master File and let them join with SQL Table.This Flat File Keeps on changing Every Day from the Transactional Database.So please Help me out With this

Thanks In Advance

This message has been edited. Last edited by: Kerry,

I hope that this flat file changes in content, not layout...
Only way I can think of is to have the contents of this flat file written to some sort of temp area in the sql server. That way there is no penalty for joining each and every record from flat to sql, since everything can be done by sql. Otherwise, you're in a tight spot.

Hi GamP,

Thanks For your Answer and that is a Good Approach but unfortunatley we don't have the Privilage to Create a Temp Table on SQL Server.
Can you Please Suggest me if there is any other way to Approach this issue

The other question here is what sort of queries will be made against this join.

Will it allways be filtered on some thing, or can the whole lot be reported on.

Ca the flat file be broken down into logical lumps that could be used in the join without too much performance issues.

it is used for adhoc Reporting and the Data would be around 500 to 1000 rows of data in the Flat File

That does not seem that large, is the flat file have a scrutcure, or is it just a list of keys for joining ?