It sounds like you want to store some text that is not valid xml in an xml field? Can you use a nvarchar field instead?

Craig Farrell (3/18/2011)

---

Eric, Rahuzz above is on the money for your solution here. Let us know if you run into problems with that solution. If you do, please...

Craig Farrell (3/17/2011)

---

JJ,

The data is not in a testable or consumable format for us. You need to read that first link in my signature, it'll explain to you what...

As mentioned before if you post ddl and some sample data in a format that makes it easy for people to help you there is little anybody can provide. Please...

Please don't double post.

See the original thread here

No need to apologize you said nothing could be taken as anything but...

inserted will ALWAYS have the new values and deleted will ALWAYS have the old values.

To do that you will have to compare inserted and deleted. This will be the new and old values. If there are a lot of columns this may end up...

abhishekc17 (3/17/2011)

---

Thanks for your reply. I was trying to work with what to told and I still have the same problem. The trigger works but the row insertion is done...

We are WAY off topic for sql server central but once again you are way over thinking this. Keep it simple. 😀

var today = new Date();

if (today.getHours() > 6 &&...

Jeff Moden (3/15/2011)

---

Having dates and times stored in a VARCHAR column is probably one of the biggest design mistakes there is in the world of SQL. If you can,...

Yes again, we are willing to help. Read this article[/url] and understand what it is saying. Just reposting the same stuff...

I will quote just about everyone in this thread....we really can't help you unless you provide some details. ddl and some sample data. Remember we can't see your screen and...

Well it will certainly be interesting if somebody figures out what is happening.

Ahh. gotcha. I got so wrapped up in aliasing the results of the case that I couldn't see the forest through the trees. 😛