Thanks for the input Bob and I value the questioning.

The maintenance gain is what I am looking for and for us with lots of small sites without local DBAs, is...

Hi Kenna,

This is a search result table and may be just the user 'tagged' items from the Search result query. A standard stored Proc which underlies a number of different...

Thanks for the input Bob.

I think we will be all right with multiple reports.

I would have liked a local table but the table in question is a list of reference...

Thanks Andrew.

I was aware that the local temporary tables would only survive the current connection's session but had thought that the dbprovider would have been able to resolve the temporary...