It looks like you're trying to write this trigger Oracle-style, where the trigger runs once for each row in the transaction. SQL Server doesn't fire triggers that way.

Try this:

create...

You're welcome.

You'll have to...

You're welcome.

Probably. Or some form of error handling on those rows, as per usual "divert to a separate workflow" kind of things.

Are you talking about extracting the values from the XML and storing them in regular tables?

If so, XQuery is one way to get there. You'll need the node and...

azdzn (1/13/2012)

---

Do you have backup of your staging database ?

Do you have a repository with all your staging database script ?

If both answers are no, I'll put that into production...

Is it possible there are rows that don't have parentheses in them? If so, it'll get an eval error.

It would depend on how much.

If it was "enough I'd never have to work again", that's very different from "enough that not only do I not have to work, but...

I'd rather he didn't. It may have some ugliness...

Use Findstring instead of Charindex. Does the same thing.

I'd put them in the staging database, just to keep it self-contained. Easier to document that way.

Use the guest account.

Edit: Just noticed you suggested about...

You could simplify to:

GRANT EXEC TO PUBLIC;

I'm not sure I'd go that far in any database I'm responsible for, but it should work.

It looks like you're looking for either one row or one column of aggregated data, right?

Why not write each query on its own, either as inline sub-queries in a single...