Okay, righto, that makes sense now. If the actual query I wrote was like so...

SELECT TOP 100 PERCENT *

FROM (

SELECT...

I've been thinking about triggers as well. That might be the best solution, in the end.

And yes, we would want to do tons of SELECTs, a...

The replication idea is something that has come to mind several times. Perhaps we get the best of both that way: Our data's actual *home* is in the...

Antares & Andy,

Thanks for the input on this. It pretty well confirms my own guesswork, but you guys are tapping into years of experience that I haven't had, and...

Folks, thanks. From a simplicity point of view, I like the notion of just pouring all the data into one database. There might be contractual issues there though;...

Antares686, thanks. That's excellent news. I hadn't seen any problems myself with our usage of this technique, but it's good to put the concern to rest.

- Tom

Thanks!

- Tom

We did battle with this same problem and came up with the same results. Saving a file in comma or tab delimited format, and naming the file "[something].csv" results...

re: "The key to views are their reusability and the simplification of maajor complex queries. However if a view does not represent a query that is reusuable for more...

And to add further complication to this happy task, if we could keep the technique that performs the aggregating flexible...that would help. Because they are signing on new Companies...