There are some differences. For example, so far as I know, there isn't a JET driver for 64-bit SQL Server. At least, not built in. If, for...

Instead of the Where Exists, I'd probably do the whole thing as a join, either to an import table, or to the CSV using Openrowset, but it's the same concept....

XQuery is case-sensitive.

"Value" needs to be "value" (all lower-case), "Extension" needs to be "EXTENSION" in the value query, and so on.

Here's a working version:

select cast('1.5' as XML) as Extension

into #T;

--

select...

Why would you forbid a solution like Jack's? It's very standard, performs well, and is easy to build and maintain.

That's why I put "often" in there.

I've seen successful solutions that had IDs, and also a column indicating which instance of the database was the source. Made it a...

I like open and with published, pre-set standards for how to get a raise and all that. Takes the uncertainty out of it.

DougGifford (5/28/2009)

---

One thought.

If the OP is using SQL Server Express there is a Maximum 4GB database size limitation.

Will this pose a problem in the future if the DB is going...

sjsubscribe (5/28/2009)

---

To gets us beyond the issues of ownership and stewardship,...

Bob Hovious (5/28/2009)

---

Nope that would only add excitement to baseball if you were allowed to clock the 1st baseman in the ribs to make him drop the ball as he...

Both of them are about that same table. I liked it when the guy said the table was part...

That's a table that someone built for you. It's not something any of us have access to.

You'll need to check if the table has any documentation at your company,...

Right-click the table

Script Table as

CREATE to

Clipboard

Paste the results into a reply on this forum. We might be able to help if there's a foreign key on it or something...

Bob Griffin (5/12/2009)

---

It's the Peter Principle. Everyone talks about it but hardly anyone follows it. Management assumes that excellence at a technical role whether it be DBA, welder,...

Bob Hovious (5/28/2009)

---

That is an impressive number of views. I always felt that The Thread is a large part of what makes SSC seem more like a...

Lynn Pettis (5/28/2009)

---

I like using surrogate keys as a primary key, but I will also...