This being the SQL Server 2005 development board, and your question being about connecting Access to SQL Server 2000, you might want to post it in a different forum. Start...

Assuming both databases are on the same server:

INSERT INTO DB1.schema.table

()

SELECT ...

FROM DB2.schema.table

Andy,

Thanks so much for posting this. Ever since I heard about the event I've been wondering how you went about pulling it off. It's something I'd like to see our...

We do this sort of query quite a lot. We've found that we use one of two patterns, one works well for a single row, one works well for multiple...

No one is going to want to look at a report that has 43 columns, let alone 430 or 43000. You'd want to look at aggregating the data in some...

Ah, true. I thought we were dealing with only a few rows. If there are hundreds or thousands, this won't work well at all. As a matter of fact, if...

The 'FROM x' should be changed to 'FROM dbo.DATA_QUALITY_OVERVIEW_TOTALS_AND_PERCENTAGES' because X was just name of the test table that I cooked up to play with your data.

You can look at...

Oh heck, I misread. You do have an ORDER BY. Oops. Sorry for the bad info.

This is a slight modification of a Jeff Moden script:

DECLARE @SQLHead VARCHAR(8000)

DECLARE @SQLBody VARCHAR(8000)

DECLARE @SQLFoot VARCHAR(8000)

--===== Populate the variables using info from the table

SET @SQLHead =...

Well, basically, if you don't need a join, don't use one. Even if there are no rows, the engine needs to look at the table to determine the fact that...

Funny, I was just reading about this, you can't use the TOP without an ORDER BY in that situation.

I guess I'm wrong, but I thought that the TOP operator strictly applied to what was returned to the client, not what was actually processed on the server. It does...

TOP simply limits the results returned to the client. All processing that has to take place on the server to gather the result set is still done, single table or...

The only thing I'm aware of that you can do by default is monitor file growth & shrinkage through Profiler. Maybe if you created a custom counter, but I'm not...

Looking through the query, it looks like you've got some design issues. You're doing joins between the billing & cancellation tables to a whole slew of other tables that all...