Thanks Paul, Revenant.

Paul, I was wondering if there would be one or two SSMS, due to the changes of it in 2012. Thanks for the info. Looks like I'll be...

For any Threadizens running SQL 2012, are you running it from a VM? Do you have any other versions of SQL installed at the same time?

I've been having issues with...

How does this work for you?

DECLARE @TestTable TABLE (LogTime DATETIME PRIMARY KEY, Qty INTEGER);

INSERT INTO @TestTable (LogTime, Qty)

SELECT '2012-01-16 00:00:00', 2345 UNION ALL

SELECT '2012-01-16 01:00:00', 2450 UNION ALL

SELECT '2012-01-16 02:00:00',...

Well, I call it a "Grouped Delimited List"

Have you checked this article[/url] out yet?

Am I the only one sensing a mid-level cert discussion coming up?

stephen99999 (1/12/2012)

---

My question is, how did you figure out to do it this way? I have not used row_number(), over, partition by very much and really don't understand it. Can...

SQLRNNR (1/12/2012)

---

Stefan Krzywicki (1/12/2012)

---

Cadavre (1/12/2012)

---

I'm going to continue posting, reading and answering questions on this site for one simple reason: I learn as much if not more than those that...

Cadavre (1/12/2012)

---

I'm going to continue posting, reading and answering questions on this site for one simple reason: I learn as much if not more than those that I've helped. Either...

Wow, good job. Definitely didn't expect...

Gianluca Sartori (1/11/2012)

---

Roy Ernest (1/11/2012)

---

WayneS (1/10/2012)

---

Roy Ernest (1/9/2012)

---

I see lots of comments regarding post counts... Does everybody have a target? I have never thought about it at all.

When I...

GilaMonster (1/9/2012)

---

mtillman-921105 (1/9/2012)

---

Then, thanks to one of Ms. Shaw’s recommended books, now I'm stuck in physics and cosmology. :blink: The book I'm reading now is The Fabric of the Cosmos,...

SQLRNNR (1/9/2012)

---

SQL Kiwi (1/9/2012)

---

You don't think 'Aaron Aardvark'...

Roy Ernest (1/9/2012)

---

I see lots of comments regarding post counts... Does everybody have a target? I have never thought about it at all.

When I get time post some thing,...

Steve Jones - SSC Editor (1/6/2012)

---

Top 10 from 2011

User posts

SQLRNNR ...