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...

Go to Books Online (BOL) and lookup COLUMNS_UPDATED and UPDATE functions. That is where I'd start. let us know if you have any additional questions after reading about...

Everyone is different. What is comfortable for one person may not be for someone else. We own a GMC Envoy, a Suzuki Forenza, and a Ford Focus. ...

Since you haven't provided us with the DDL (CREATE TABLE statement) for the table, the code you are running, or sample data, its hard to say for sure. I...

RBarryYoung (3/31/2009)

---

Lynn Pettis (3/30/2009)

---

You...

Double posted. Please reply here.