OK:

1) You should not be using cursors for this, and definitely not nested cursors. ...

Luke L (2/1/2009)

---

It's not just the description I'm talking about though. The subject line itself is truncated and there's no place to see it within the site (or at...

No problem, it happens to all of us. Just glad that I could help. 🙂

i would suggest seeing if you can get it to work to that same URL and with that same XML outside of SQL Server.

It would also be helpful to see the code.

I do not see your listing for the Production.Product table. Since that is the table that your Trigger is on, then that is the format that the INSERTED table...

Just to clarify: the purpose of...

We cannot see the error message from here. Can you tell us what it is?

Thanks,

OK, I'm back and can test them now...

...And actually, both of these work for me. 🙂

[Oh wait, maybe it's this...

select @XML.value('(/row/@*[2])[1]','varchar(50)')

Sorry, I don't have time to test these right now... 🙁

Well I am sure no XML guru either, but doesn't this work?:

select @XML.value('(/row/@*)[2]','varchar(50)')

Though admittedly, every time I think that I have something figured out in XML and then try to...

Marios, I think that what you gav eus before was the estimated execution plan. Can you get us the actual execution plan? IT should also be avaialable through...

Yes. Use a temporary table:

create...

Heh. I wouldn't spread that around the office, Jeff. 😀

Congratulations, Steve! Now we can honestly say that there's a million reasons to use this site. :w00t: