Anything with a 8.0 version on it is based on SQL 2000. So either it IS a SQL 2000 server, or it's a DB running in 2000-compatibility mode.

This unfortunately...

Check for a trigger on the table you're updating. The direct update itself doesn't look to be the issue.

Agreed - as long as I don't...

Keep in mind that you will likely end up owing "self-employment taxes" on anything you do, usually above and beyond usual taxes.

You might care to take a read on what...

For what it's worth I took my own advice. I remembered having access to a 2012 downloaded copy, so I installed it.

Fresh out of the install, this works:

with base...

Jeff Moden (5/3/2012)

---

drew.allen (5/2/2012)

---

Furthermore, it's just clearer. If you specify CROSS JOIN, it's absolutely clear that you are expecting the Cartesian product of the two tables.

I simply see no...

jcrawf02 (5/1/2012)

---

The real problem with this is the use of "never, ever". There are cases where this may be exactly what you want to do, and cases where this would...

Peter Maloof (4/30/2012)

---

And sometimes metrics become the end-all;...

ROUND isn't changing the data type, so the numeric(28,12) still applies (which is padding the 0's back in).

Two choices: either handle the truncation within the report OR add a cast...

I don't really see the issue as whether to use metrics, but WHICH metrics to use. On this particular example, we had something similar but it had to do...

Assuming your file DID load 100%, try a query like the following (you will have to fix the column name since you didn't specify what yours is):

select n.value('(./text())[1]','varchar(200)')

from XmlImportTest...

Michael Valentine Jones (4/25/2012)

---

Matt Miller (#4) (4/25/2012)

---

Michael Valentine Jones (4/24/2012)

---

I would think that venting the waste heat into a cluster of greenhouses would make a lot of sense. Grow...

Michael Valentine Jones (4/24/2012)

---

I would think that venting the waste heat into a cluster of greenhouses would make a lot of sense. Grow expensive flowers or vegetables in places...

All of the steps you are identifying are definitely possible:

1 - No sense in using FOR XML, since you already have XML. Simply output that column.

2 - easiest way...

Is there a unique or primary key on the table? I've seen that type of error from applications where the datasets couldn't identify a unique key of some sort.