Phil Parkin (3/13/2015)

---

Gary Varga (3/13/2015)

---

Yes!!! Commented out code. That's what source code control is for. If you need to leave a reference to old code then just leave a comment...

Gary Varga (3/13/2015)

---

I was going to try and say "no comment" in a witty way but as I am not first to highlight the issue (and I am not always...

Koen Verbeeck (3/12/2015)

---

below86 (3/12/2015)

---

One huge problem I see so...

One huge problem I see so far is when...

Jeff Moden (2/19/2015)

---

The correction I would make is that the sources that you mention aren't what I'd call "heterogeneous". The sources that you mention are very specific and, although...

CELKO (3/11/2015)

---

SQL is supposed to be a declarative language, which means we want to write a single statement to answer a query or do a task. We do not want...

UNCLE! UNCLE! To SQLguy-7... Ignore my posts, everyone else here is a better SQL developer than me. 🙂

Nevyn (3/10/2015)

---

below86 (3/10/2015)

---

I quess erything I deal with is...

I quess erything I deal with is batch processing...

Just do what makes it easier for you to understand, don't worry about what others think. I like to go with the KISS method, Keep It Simple Stupid. ...

+1

Jeff Moden (3/4/2015)

---

below86 (3/4/2015)

---

Why did the UNPIVOT not work for you?

Here is what I came up with:

SELECT l.ID, l.Name, l.YrMnth, l.Enrollment

FROM (SELECT ID, Name, [201401],[201402],[201403],[201404],[201405],[201406]

FROM #Table1) p

UNPIVOT (Enrollment FOR YrMnth...

Why did the UNPIVOT not work for you?

Here is what I came up with:

SELECT l.ID, l.Name, l.YrMnth, l.Enrollment

FROM (SELECT ID, Name, [201401],[201402],[201403],[201404],[201405],[201406]

FROM #Table1) p

UNPIVOT (Enrollment FOR YrMnth IN ([201401],[201402],[201403],[201404],[201405],[201406])

) AS...

Thanks for...

Eric M Russell (2/11/2015)

---

The order of columns in the insert does not matter to the optimizer or engine. Also the order of columns in the SELECT, WHERE, and JOIN do...