Some parts aren't entirely clear, but the general idea doesn't seem too difficult.

If you could offer a concrete example, that would make it much easier to help you. (E.g....

Hugo,

Again, thank you for the detailed reply, and taking the time to respond. I apologize that I did not include all of the necessary details -- the QueuedTasks table...

Hugo,

Thank you for your detailed reply. To start, the results of the query you had me run are "0, OFF, 0". I'm assuming this doesn't point to an...

Well.....SQL Server does have an engine, so....

Wow! I stand corrected. I should have tested this out before commenting. I could have sworn that I came across issues where a global temp table was...

I got this one right, but I don't think the correct answer is listed. I could be wrong, but I think, in these circumstances, Query 3 would succeed both...

PHYData DBA (2/23/2015)

---

bantrim (2/23/2015)

---

PHYData DBA (2/23/2015)

---

bantrim (2/23/2015)

---

Eric M Russell (2/23/2015)

---

PHYData DBA (2/23/2015)

---

bantrim (2/22/2015)

---

Eric M Russell (2/22/2015)

---

On occasion I've used: SELECT.. WHERE 1 = 0. For example, I may want to...

PHYData DBA (2/23/2015)

---

bantrim (2/23/2015)

---

Eric M Russell (2/23/2015)

---

PHYData DBA (2/23/2015)

---

bantrim (2/22/2015)

---

Eric M Russell (2/22/2015)

---

On occasion I've used: SELECT.. WHERE 1 = 0. For example, I may want to select into a...

Eric M Russell (2/23/2015)

---

PHYData DBA (2/23/2015)

---

bantrim (2/22/2015)

---

Eric M Russell (2/22/2015)

---

On occasion I've used: SELECT.. WHERE 1 = 0. For example, I may want to select into a temp table that...

PHYData DBA (2/23/2015)

---

bantrim (2/22/2015)

---

Eric M Russell (2/22/2015)

---

On occasion I've used: SELECT.. WHERE 1 = 0. For example, I may want to select into a temp table that is derived from...

Eric M Russell (2/22/2015)

---

On occasion I've used: SELECT.. WHERE 1 = 0. For example, I may want to select into a temp table that is derived from another table but...

PHYData DBA (2/19/2015)

---

bantrim (2/19/2015)

---

I guess I get to be in the minority here. I don't use it everywhere, but it does have its purpose. One notable example is...

I guess I get to be in the minority here. I don't use it everywhere, but it does have its purpose. One notable example is in building dynamic...

Jeff Moden (1/11/2015)

---

I can't speak for Kevin but I roll my own, as well. Two different types but both use carefully created, hardcoded triggers. Notice that I didn't...

Eric M Russell (1/12/2015)

---

bantrim (1/12/2015)

---

Eric M Russell (1/12/2015)

---

Using hash or checksum techniques to detect modifications to bulk numbers of records is inefficient (it has to read and hash all columns)...