Good question. +1

Good basic question. And thanks to Tom and Hugo for the explanation. 🙂

Good one.

Good question. +1

Lolz. The date of the question posted and the points given to it quickly gave me a clue. Also I was alert enough for this particular date as I was...

An easy one. but good basic exercise. 🙂

Pretty good question (though you can get some issues based on collations etc as I work on environment based on different collation then default). Interesting. 🙂

A free point is always welcome. 🙂

This question definitely needed some research, specially for me. I knew about makepipe and readpipe but had to work hard for odbcping. But got one point for my hard work...

Column 'ds.Region' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause."

You are going to get this message one...

Thanks guys for the input, however as Gazareth said it's going to break after the limit.

Just want to clear if this is something related to any configuration setting ? Because I have never observed not heard this kind of problem anywhere.

Anyone ??????

Heartiest congrats. 🙂

I agree with all the people's comments. No one crack a three hour long interview without knowing anything. Remember you are not replacing the DBA but working with...

Definitely something to do with the kind of data you have inside the table. Could you provide some of the data inside the table Table for COL1 ?