You don't need to record the "new value" for a valid audit log. That's in the table and can be retrieved from there. Save yourself some storage space,...

Jeff Moden (5/18/2012)

---

And someone please post one of the XML triggers. One of you 3 folks recommending this should have one right at your fingertips, yes? I'd like...

I once built a whole audit system for a database using For XML. Do the columns as "NullIf(Deleted.MyColumn, Inserted.MyColumn) as MyColumn", in the Select, and you very cleverly get...

For a dynamic column name like that, you'll either need to use an Unpivot statement that lists the months, or you'll need to use dynamic SQL. Sounds like you...

mtassin (5/18/2012)

---

Gazareth (5/18/2012)

---

dwain.c (5/18/2012)

---

I don't recall that being the error I was getting but since it is pretty explicitly saying that I was trying to be a naughty boy, I...

dwain.c (5/17/2012)

---

GSquared (5/17/2012)

---

If you want to mess around with it a bit, it occurs to me that you could use an Output clause on a Merge statement to end up...

If you want to mess around with it a bit, it occurs to me that you could use an Output clause on a Merge statement to end up inserting two...

sturner (5/17/2012)

---

GSquared (5/17/2012)

---

I know a DBA you can get really inexpensively.

It's mainly because he's...

I don't get what you're trying to do with "AS" there, and neither does SQL Server.

"AS" in a Select statement indicates a column alias, but you have a data function...

9 months after New Year's Eve parties. Yep....

I know a DBA you can get really inexpensively.

It's mainly because he's never done...

Gullimeel (5/17/2012)

---

I am not saying that it will make your future tuning easy or something like that. You have to keep looking for whether you query is still performaning better...

You're welcome.

I have my own technique for interviewing. It aims more at personality and intelligence than at specific skillset. Itdoes include the skills needed, but secondary in importance. ...

Considering that you need to do two actions if you get a match (create new and cancel old), Merge isn't the right solution.