Sean Lange (3/7/2013)

---

alan_lynch (3/6/2013)

---

I am trying to insert records into the database as follows

insert into lookuptable

select * from lookuptable1

which produces

Msg 2627, Level 14, State 1, Line 1

Violation of UNIQUE KEY...

Primo Dang (3/8/2013)

---

You forgot the part about nesting limit - which, by the way, I...

opc.three (3/6/2013)

---

I'll second that. I almost exclusively favor traditional temporary tables over the use of table variables. Performance is one reason, which you may be experiencing first hand, and ease...

Steve picked a bad day to be away from SSC!

The errors in the answer set seem to arise from a misreading of the BOL text and/or a logical error in...

Lynn Pettis (3/7/2013)

This:

That's a lot different than watching opponents (and teammates) repeatedly get mugged (like lying-face-down-in-the-dirt-with-cleat-marks-up-the-back-and-over-the-top-of-the-head mugged) for 45-50 minutes, then getting whistled when your feet just get tangled up...

Lynn Pettis (3/7/2013)

---

wolfkillj (3/7/2013)

---

Lynn Pettis (3/7/2013)

---

jcrawf02 (3/7/2013)

---

You're absolutely right, the players should pay attention to what the ref is calling, not what the rules say, because then they know what...

Lynn Pettis (3/7/2013)

---

jcrawf02 (3/7/2013)

---

You're absolutely right, the players should pay attention to what the ref is calling, not what the rules say, because then they know what they can get...

Lynn Pettis (3/7/2013)

---

Sean Lange (3/7/2013)

---

Lynn Pettis (3/6/2013)

---

Several years ago my oldest daughter's JV soccer coach once confieded "I knew we were in trouble when half the team asked what was...

daglugub 60457 (2/25/2013)

---

I took the time to create that scenario because I am asking for help so I wanted to be specific as possible. I guess that backfired huh.

Here...

Tom Bakerman (2/25/2013)

---

Does the query optimizer make use of transitive equality? By that I mean if A = B and B = C, then A = C. Does...

pdanes (2/22/2013)

---

Bill Wehnert - The Tom Swift books (I had a set, too) weren't written by Asimov. http://en.wikipedia.org/wiki/Tom_Swift

I've been a gadget-geek all my life, since I was a little kid,...

Atari 800XL - w00t! This was the first computer that my...

I'm wondering - why do you say that included columns would reduce overhead? I...

ldorian81 (2/21/2013)

---

L' Eomot Inversé (2/21/2013)

---

Good question.

I'm glad that missing out WITH is deprecated though, so that teh answer to this question will change in the future. In fact I...

venkat9.sql (2/20/2013)

---

wolfkillj (2/20/2013)

---

L' Eomot Inversé (2/20/2013)

---

Nice interesting question.

I really must upgrade and get SQL2012 so that I can start playing with this stuff instead of just reading about it.

If people...