I need to understand two things in this part of the code. What does those red expressions in quotes mean and what does T.N mean? Probably stupid questions but I...

Steve Jones - SSC Editor (12/6/2011)

---

If you need nulls or 0s in there, then you would add that logic, and replace the values in the SELECT with a NULL based...

No, actually it is set as a varchar(50) column. Should I change it to...

Tom Brown (12/6/2011)

---

There will be a much simpler and faster way of doing this problem without using LOOPs. If you are interested I can sort out a few...

Guys, thank you very much for your support.

I will take my time and make an in-depth research of what you have written so far.

To be honest, this is a task...

Ninja's_RGR'us (11/14/2011)

---

year - month

2011 - 1 - January

2011 - 2 - February

2011 - 3 - Marche

If you sort by column 1 & 2, the sequence will be correct in the...

bitbucket-25253 (11/13/2011)

---

First of all realize that there is not a "next row", in a SQL table, rows are not guaranteed to be returned in the order in which they were...

Ninja's_RGR'us (11/14/2011)

---

Classic demand / mistake.

Either return the date of the first of the month or return YEAR and month in 2 separete columns.

Then sort by those values, but present the...

I should have write the second question more clearly, sorry.

I am able to use SELECT command for the datetime values in the date column and show them in a month-year-only...