jlennartz (10/31/2012)

---

Not sure what real world value this question would be as it does not keep the sales attached to the correct UserName and UserID. Seems like...

Raghavendra Mudugal (10/30/2012)

---

Just trying to understand...

As it says OVER (ORDER BY Sales)...

Thanks for the intro to a new SQL 2012 function (Making me itch for our app to move on from 2005!). I love the idea of this new function...

Jan Van der Eecken (10/23/2012)

---

Tigers or Giants, doesn't really matter to me who wins. May it be a great series!

BTW, I still haven't understood why it is called the "World...

I was born and raised in San Francisco, my dad took me to Giants games at Seals Stadium when the team moved west in 1958, I saw Marichal's no-hitter against...

Koen Verbeeck (10/22/2012)

---

Lokesh Vij (10/22/2012)

---

kapil_kk (10/22/2012)

---

in this case the max ident value would be 101 as with first insert statement the value of ident was 100 and with another insert...

Good topic for a follow-up QOD (hope I don't steal any thunder here):

If the code presented had one more statement amnd asked for the max(Ident)...

CREATE TABLE IdentTest

( Ident INT...

Markus (10/19/2012)

---

looking more like a Cardinal / Tigers series... rematch of 1967/2006.

Go Tigers!...

Markus,

At this point, it's just so much FUN, right? I like to consider myself more a BASEBALL fan than just a fan of the team I watched growing up....

"Reds and Tigers"? oh. You mean the Giants and A's. (let me name the two series with West...

Re: Minor League Baseball....

I hope New Yorkers know how good they've got it. I haven't been in the Apple for a number of years now, but have a sweet memory...

Re: Myth that @Table variables are only in memory.

It never made sense to me that people would think that MS would develop an open-ended methodology to manage data in table...

SQLDCH (7/11/2012)

---

Being a Giants fan, I'm pretty excited to see the boys in orange and black do well. It helped to justify their place in the game even with...

I nearly bit at the implication that SQL 2012 added syntax to allow truncating a table that met certain conditions. Had to find BOL 2012 online to disuade myself of...

Steve Jones - SSC Editor (7/10/2012)

---

Tim Mitchell (7/10/2012)

---

Prince Fielder looked good last night. I was surprised at the vitriol from the crowd toward Robinson Cano. Is it just...