You're probably running into the usual problem with mixed data types in Excel columns. Search online for "IMEX" and Excel, and you'll find the solutions to that.

You'll either need to use the quirky update running totals routine (search for "running totals" on this site), and accept the risks/liabities that has, or use a cursor, to make...

Flood the Tigris for Truncate?

If you can do it to a bagel, can you also do it to a donut?...

No. I think that a trigger is most likely not the best solution.

Can you build a separate database with a log table in it? Is there an identity-type...

What have you tried so far?

I don't see actual table definitions in here, so I can't really build the query for you.

What it looks like is one table (ControlLog) is in a one-to-many relationship with...

Kris Sledge (10/11/2010)

---

...There was a trigger on a table that was making a remote call via xp_cmdshell(no flame war about tjis please, I don't like the option either) to another...

I don't see where PVal and such are defined in your table.

Beyond that, are you trying to use "For XML" to produce this from an SQL table, or are you...

On review, it also looks like your trigger will probably produce incorrect results if more than one row is inserted at a time. Can't be sure about that, since...

The subquery in the If statement is probably the one that's blowing up.

It looks like you're trying to increment a number in a column. Why not use an Identity...

How close to "when a new row is added" is close enough?

I'd tend to not mess with a vendor's database, because it often breaks terms and nullifies support contracts, and...

I tend to use one or another source control solution for this. That's the recommended practice on just about any sort of file that can be modified by multiple...

Since it's SQL 2000, the best bet will probably be a UDF that uses a Numbers or Tally table to split it apart into rows, based on the commas. ...

I must be missing something. Why would restoring anything break the log chain?