ChrisM@Work (7/9/2013)

---

Beautifully illustrated, well written and easy to follow. Even though the rCTE method has been shown more than once to be somewhat slower than FOR XML PATH, there are...

Thanks for the question!

Are you looking for something like this?

DECLARE @table TABLE

(eid INT, Remarks VARCHAR(10))

INSERT INTO @table

VALUES(17074, 'OFF DAY'),(17074, 'ABSENT'),

(17074, 'Late'),(17074, 'HALFDAY'),

(17074, 'ABSENT'), (17074, 'OFF DAY')

SELECT eid ,

SUM(CASE Remarks WHEN 'OFF DAY'...

Thanks for the question!

Good read. This has actually bit me in the butt before with almost the exact scenario you posted in the article.

Peter Schott (7/2/2013)

---

I'll have to agree with what a lot are saying.

1. Variable width, if possible - something that takes advantage of the available reading area. On my laptop, tablet,...

Great question to end the week and great explanation Hugo. (I always get something from them)

And thank you for this

Hugo Kornelis (6/21/2013)

And if you're still unconvinced, run the code...

Danny Ocean (6/14/2013)

---

Lokesh Vij (6/13/2013)

---

My eyes winked when I looked at this code

DROP TABLE [dbo].[IndexTable]

SELECT * FROM indextable

Qotd aks about "the output of select statement", but as per the code...

+ 1

+1 Great question Hugo. I completely overlooked the hint in the title. I also seemed to...

sestell1 (6/10/2013)

---

Lokesh Vij (6/9/2013)

---

+1

Same here, I also marked...

Thank you for the great question and clear answer.

Ez Pz. Thanks for the question.

+1. Never should have doubted

WWDMark (5/15/2013)

---

+1 to that but I was looking for a catch somewhere in the answers though (paranoid...