The basic syntax will work in Oracle, but you can't have the brackets.

Since I know just how HORRIFIC the XML EXPLICIT statements can be, I shudder to say this, but go ahead and post the query (maybe as an attachment) and someone...

I don't believe the CREATE TABLE scripts can be made generic, but I could be wrong. As to the INSERT scripts, just be sure you're, for want of a better...

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...