The Excel driver is a bit squirrelly in how it determines the datatype of the source. It looks at the first few rows and then tries to determine datatype based...

To synch the databases, you'll want to be able to see what bugs are in one but not the other. Something like:

SELECT

 eng.BugNumber

 ,eng.BugDescription

 ,spa.BugDescription

FROM

 EnglishBugTable AS eng

 FULL OUTER JOIN SpanishBugTable as spa ON

  eng.BugNumber...

Without more information, it's going to be hard to help you with this, but I would guess from your post that you have two tables, one in English, the other...

Performance, security, data integrity (Access corruption issues can be quite nasty), enterprise reporting, etc. If they are looking for ease of use for the end user, you can create a...

While I'm not an ASP developer, MS products all seem to handle xml files just fine, so you shouldn't have to do anything. The XML parser should convert & right...

Because SQL Server is set based, not row based. For instance, "SELECT colName FROM tblName" might return rows in the same order every time, SQL does not guarantee that it...

When you say distinct and duplicate, are you referring to the InvoiceBatchID? I made that assumption based on the code you pasted.

If that's the case, try "SELECT Count(Distinct InvoiceBatchID) FROM...

The ampersand, apostrophe, and quote, as well as less than and greater than ( < and > ) are reserved characters in standard XML format. Many tools that expect XML...

There is no "r" in your GROUP BY statement.

It won't do what it seems like you're wanting anyway, as you aren't aggregating. Based...

Upon reading your latest message, it sounds like you want all rows where the values in col1, col2, and col3 taken together appear in more than 1 row.

Try: SELECT col1,...

I think the confusion might be based on your definition of the terms distinct and duplicate. Both imply that the combination of all of the columns in a select list...

The only reason I would recommend my method over your's, Frances, is on the chance that some of the entries don't have a percent sign.

With both of our code, 100%...

That didn't work well, so we'll try again

SELECT intNewField = Cast(Replace(vchOldField,'%','') AS int)

For a quick and dirty option, just use something like:

SELECT

In your original post, you used multiple variables as the string was over 8k. In your most recent post, you use a single variable to hold the MDX query. Did...