This is a sql server forum, not mysql.

amos-870870 (12/5/2011)

---

I do believe this was the first thing I tried, but was under the impression that even in the view I still could not update to tables in the...

p-nut (12/5/2011)

---

eseosaoregie (12/5/2011)

---

I was just wondering if there was another way of getting the same output with a different query. I have tried to look up multi aggregate pivots on...

eseosaoregie (12/5/2011)

---

I was just wondering if there was another way of getting the same output with a different query. I have tried to look up multi aggregate pivots on google...

Something like that should do it.

UPDATE view_set_DispInvNoComp

SET ...

Yes the first update changes the data and there's nothing left to do in the 2nd one.

You need to do both updates in the same statement.

I was hoping the stats would help the plan but they don't.

I don't see any low hanging fruits here. It takes time because there's a lot of work to...

L' Eomot Inversé (12/5/2011)

---

Ninja's_RGR'us (12/5/2011)

---

L' Eomot Inversé (12/5/2011)

---

That's startling. I...

That changes nothing.

What are you trying to debug?

eseosaoregie (12/5/2011)

---

I used a temp table but the query took exactly the same time.

I am not really sure on how I to create PIVOT with multiple aggregates. Could you give...

Please...

If it's ran precisely between the 2 updates then yes.

The answer changes depending on the isolation level of all the connections involved.

Change from @tbl to #tbl. Post back on how much that helps.

And no other backups I guess?

Is this a prod server?

Reverse the logic

If not exists () Create blank trigger

;

ALTER TRIGGER...

P.S. Please start a new thread next time.