GabyYYZ (4/29/2010)

---

Lynn Pettis (4/29/2010)

---

WayneS (4/29/2010)

---

Makes you wonder... Here, the OP (with 1800+ points) can't pull apart two simple nested cursors with 5 subqueries in that last nest into some reasonable...

IMO, the best place for cursors is in other peoples code... when...

Lynn Pettis (4/29/2010)

---

WayneS (4/29/2010)

---

Makes you wonder... Here, the OP (with 1800+ points) can't pull apart two simple nested cursors with 5 subqueries in that last nest into some reasonable code....

Indeed it would be. And he did spell out Terabyte.

Maybe the OP has been off watching the db...

If I can solve it, then it definitely doesn't take a guru to solve this. Though they can probably make it more efficient.

-- See how this starts off with a...

Makes you wonder... Here, the OP (with 1800+ points) can't pull apart two simple nested cursors with 5 subqueries in that last nest into some reasonable code. And here, he...

This code uses an in-frequently used form of the UPDATE statement. Read the article mentioned in the code, and understand it (especially the rules) before putting this code into a...

Grant Fritchey (4/29/2010)

---

Ah, so the FULL...

Hmm, 77 secs / .005 sec =...

Gail - welcome back... hope your break refreshed you!

Especially singe "G" is right under "T" on the keyboard...

Edit: but then again, he did write out "Terabytes" in the first post...

This does it without cursors.

SELECT [User] = su.name,

[Table] = so.name,

[select] = IsNull(max(case when sp.action =...

You do know...

ninel,

First, thanks for supplying the DDL and DML to create some test data... that helps!

Can anyone please help me with a query that can pull the value of the CurrentTalk...

Duplicate post. Please post responses at at the other post.