Karthik,

It looks like you're ordering by the value column, and for the first three rows putting in the appropriate variable?

If so, how does this work for you?

DECLARE @Vars TABLE (ID...

I know voting isn't over yet, but does anyone know if PASS has a date by which speakers will know if their submitted sessions have been selected for the Summit?

Jack Corbett (5/16/2011)

---

Saw Steve's mention of Denver for next year's US SQLRally, I say US because there is SQLRally Nordic in Sweden in November and I believe Australia is in...

Have...

jcrawf02 (5/12/2011)

---

why do I need an iPad2? suggestions? (32GB wifi version, guy at work selling it)

my list so far:

1 - I can use it for my schoolwork online, reading...

I have to say that I thoroughly enjoyed SQL Rally. I thought that a couple of the sessions were not up to par; however the others that I saw were...

Oh, just in needing...

TT-131210 (5/11/2011)

---

No, I am not sure how to do that but I have seen that syntax but I was not sure how that worked. Also, the stored...

tictoc (5/11/2011)

---

Thank You for the links and the schooling 🙂 Makes more sense now!

I try and not to be some copy pasta gangsta and learn what each item step...

Good question - thanks!

Tom.Thomson (5/11/2011)

---

Nice question.

One niggle: asking people to assume that a schema is valid when a table doesn't have a primary key may encourage a very bad habit if some of...

tictoc (5/11/2011)

---

It's eating through 300,000 rows like corn now 🙂

BUT

I need to understand more on

DECLARE @Colslist VARCHAR(MAX)

DECLARE @Cols TABLE (Head VARCHAR(MAX))

INSERT @Cols (Head)...

Jeff Moden (5/11/2011)

---

Also, the delimiter isn't actually a space character, in this case. Rather it's the second character of a space followed by either a letter or a digit....

Praxo (5/11/2011)

---

I am trying to understand following deadlock graph. I spent some time on my own and google-ing and eventulally came to this forum.

Here is what it has captured.

There are...

I'm with...