Happy New Year to you too Steve and all the forum members. 🙂

Nice one. I was sure about the wrong ones. 😉

Good one. 🙂

Easy QOTD to end the year on good note.

Thanks Steve and all for making the year wonderful and interactive with QOTD efforts. And a wish you a wonderful year...

Ahh... I had read a little bit about CMS so got it right. Good QOTD. 🙂

Wow... Thats a good one. I don't use cursors because of some obvious reasons and hence have to do some r&d for it's each question. 🙂

Very good question. 🙂

Merry X-mas to all the members. 🙂

Good question.

Good question. 🙂

Guess what, simple straightforward question for those who read. I was the fortunate one. 🙂

The solution provided looks good. However in my actual scenario, there are around 15-20 columns in master table (all have to be included) and around 30 columns in details (of...

+1. Seriously.

Thanks Sean/Kurt for the wonderful query.

One update to the requirement and one query.

Modification is that there might be some students who have only one or two or all of the...

I was really not sure about the answer and it was hit in the dark. Definitely learned something today. Thanks Steve. 🙂