RJ (3/31/2009)

---

Yes. Other than the key column we wouldn't need to add "or ((d.col5 <> i.col5) or (i.col5 is null) or (d.col5 is null))" to a column that is not...

No, just half baked! 😉

RJ (3/31/2009)

---

this is a good query but would fail if there are NULL values in deleted. i think the below query would fix it. But, anyway I have to double...

JJ B (3/31/2009)

---

Example: I have a co-worker who a couple years ago bought an expensive, big gas guzzling SUV because she "likes the feel of it" and "feels safer in...

Does this give you what you want? Realize that this is going to be a large insert query for your actual table.

insert dbo.audit_abc (col1,col2,col3,col4,col5,audittype)

select

d.col1,

...

JJ B (3/31/2009)

---

I'm 5 feet, but I've had much taller passengers who have had no problems getting in and out of my car. The car body is a standard...

No prob, Flo. Easily corrected error.

SELECT

*

FROM

Table1

LEFT OUTER JOIN Table2

ON (Table1.GroupID = Table2.GroupID

...

GSquared (3/31/2009)

---

JJ B (3/31/2009)

---

Concerning the discussion on comfort: There's all kinds of comfort. I find the Civic Hybrid to be extremely comfortable in several ways. I'm not...

I don't see no commas, just ellipses (...).

RJ (3/31/2009)

---

For example, take my query:

insert dbo.audit_abc (col1,col2,col3,col4,col5,audittype)

select d.col1,d.col2,d.col2,d.col4,d.col5,

case

when i.col1 is null then 'delete'

else 'update'

end

from deleted d

left outer join inserted i

on d.col1 = i.col1

where col2<>col2

and col5<>col5

In this query except col3...

To clarify, if col2 and col3 are updated, don't audit regardless if any other columns are updated? Or, if only col2 and/or col3 are updated don't audit? Sorry,...

It would help if you could provide the DDL (CREATE TABLE statement) for the table, some sample data, and the expected results based on the sample data.

jfox (3/31/2009)

---

I find it funny that Prius owner Steve Jones is all proud of his mpg ratings and 'savings'. My daughter bought a Yaris for a lot less that...

The only way to know is to test the different options and check the statistic io, statistics time, executions plans, and anything else people may suggest. between them.

I'd recommend a...