picant (1/17/2011)

---

I guess I am missing how the business reason behind what you are doing isn't meshing with your fruit analogy.

Using analogies doesn't always help us help you solve your...

Ninja's_RGR'us (1/16/2011)

---

Well here's to plan B. Sending mails from triggers is a bad idea anyways.

Make a log table that saves the history of the processed orders.

Then create a job...

Hi Jota,

I don't see exactly what would cause that error, but I do have to ask why this trigger is on that table?

That table seems like it might hold order...

Have a read of this Blog Post on BeyondRelational.com : http://beyondrelational.com/blogs/jacob/archive/2010/02/06/how-to-generate-cdata-and-namespace-declarations-using-for-xml-explicit.aspx

Preferably, I would say have two queries

IF @ID>0

SELECT column_list

FROM Table as Alias

WHERE ID=@CaseID

ELSE

SELECT column_list

FROM Table as Alias

WHERE RMARequestedDate...

That makes very little sense in terms of a set...

OP answered own question while I was typing! Answer removed.

Tara-1044200 (1/14/2011)

---

I can run the follwing query in sql 2005 but not in sql 2008 using local server name in the prefix, why?

SQL 2005(serverA) = select * from ServerA.DB1.dbo.emp =...

This may be the source....

http://www.sqlservercentral.com/Forums/FindPost644446.aspx

Jeff Moden (1/14/2011)

---

mister.magoo (1/4/2011)

---

As you only have three small strings to make initial caps I would personally stick with your first thought....

UPDATE dbo.wce_contact

SET

firstname= STUFF (lower (firstname), 1,...

Jeff Moden (1/13/2011)

---

mister.magoo (1/13/2011)

---

The two slashes are the XML equivalent of...

I suggest you ask a DBA or a programmer to look at this for you - anything we tell you here should not be used unless you understand it.

SSMS Tools : Free : Does a reasonable effort for a...

As I said before, the table variable which holds fileCode need altering - currently it can only handle 4 characters.

Also, your WHERE clause prevents you selecting fileCodes like '0192ZZ' because...

The two slashes are the XML equivalent of a % at...