The above shows that there are crappy programmers in MS as well.

It's a good example how NOT to do triggers.

Graeme, if you open BOL on topic "CREATE TRIGGER" you'll read that trigger is just a stored procedure.

Don't make something supernatural from it.

You better check the logic of your...

Graeme100 (10/30/2007)

---

Sorry...idiot that I am..I left a bit out

UPDATE y

SET y.col1 = getdate()

FROM table1 y

INNER JOIN

(select a.id1,a.column2

FROM Table1 a

LEFT OUTER JOIN Table2 b on CAST(b.id AS INT) = CAST(a.ID...

Select cannot block any process even if you not to use (NOLOCK).

Because it applies shared locks.

Look what blocks your SELECT process. There must be some updates involved.

Or probably you've got...

Only second?

Man, you're good!

😉

rog pike,

Did not have time to read all articles you referenced, but this one:

Itzik Ben-Gan and Sujata Mehta

OVER Clause and Ordered Calculations

http://www.insidetsql.com/OVER_Clause_and_Ordered_Calculations.doc

is horrible.

They use correlated subqueries everywhere, name it "set-based...

Peter Gadsby (10/29/2007)

---

Trigger yuk... I avoid those as they convert a set based query to a row based query which slows the system down dramatically especially in a data warehouse...

Editor's Note: Reply censored by the Steve Jones

Jeff,

At the end of the day you agreed with Kenneth.

You said that result was ordered wrong way because of wrong query.

Exactly as Kenneth stated from the very beginning: it's the...

Kenneth, I could not answer you immediately, it gave you some time to withdraw your post.

But you did not use that chance.

So, it's your fault. 😉

Kenneth Wilhelmsson (10/25/2007)

---

Ah, just small...

ReturnValue from ANY stored procedure ALWAYS is int.

What that derived table is for?

Your LEFT JOIN eliminates any filter on the rows, and whole table gets updated.

Not sure thgis is what you're trying to achieve.

Try this:

SELECT y.ID, y.col1,...

Ask someone who can.

As I said - bad design.

Incremental updates are ALWAYS more effective.

"Full refresh" is something what should never exist in database.

What kind of data do you load?

How often do you perform this process?

If assume...