We don't mark them as solved. They will always stay "open". That way if somebody comes along in two...

???

This topic comes up around here from time to time. Pretty much everytime the OP decides to go back to the drawing board because the complexity of this is crazy....

And be careful of the subselect in your join condition. This will not return all rows if there are more than 1, it will return a single random row.

Here is...

The only way rows are removed from a table is with a delete statement. If you want to track this you could setup a delete trigger on the table(s).

So does this app role have permission to select from that table?

I have found in the past that documentation for systems like this don't exist or are horribly wrong more often than not. I suspect it is either the original "author"...

You're welcome. Does this mean you finally have your answer? 😛

SQL_ME_RICH (5/7/2012)

---

Trust me - it has been an...

njdevils39 (5/7/2012)

---

Sean Lange (5/7/2012)

---

You seem have me lost...

What does that mean? What is the question?

Did you notice...

You seem have me lost...

What does that mean? What is the question?

Did you notice that you have...

njdevils39 (5/7/2012)

---

Sean Lange (5/7/2012)

---

njdevils39 (5/7/2012)

---

Sean Lange (5/7/2012)

---

What is wrong with what you posted? One thing I would do differently is don't bother creating temp table, then filling the temp table,...

How about since you never actually posted a...

opc.three (5/7/2012)

---

I have never seen such a thing in the wild...I was wondering if inserts might even be blocked so ran a quick test...they work. I also ran an execution...

Isn't this just a continuation of your thread from a couple months ago? It does not look like we ever found a resolution for that one.

http://www.sqlservercentral.com/Forums/Topic1255283-145-1.aspx

How about we get some...