More questions like these please, had to configure, drop, recreate, drop, recreate, fail to get to the answer. 😀

+1

I...

Fantastic question. Thank you.

wolfkillj (11/15/2013)

---

ksatpute123 (11/14/2013)

---

Thank you for the quick reply.

I have already tried using this approach. It is based on the assumption that there will be only one value per column corresponding...

dwain.c (11/17/2013)

---

If contact number is the only column that may have duplicates, you can also do it like this.

DECLARE @temp TABLE(id int, name varchar(50), age int, contact_number varchar(50));

insert into @temp(id,name)...

Thank you for the quick reply.

I have already tried using this approach. It is based on the assumption that there will be only one value per column corresponding to a...

Koen Verbeeck (11/13/2013)

---

First of all, this question is way too easy. Enterprise has all the features, so you don't even have to think.

Secondly, developer is the same as enterprise feature-wise,...

Too easy. Thanks for the points.

I fell in the trap 🙁 . Nice back to basics question.

Super easy. 😀

I had to google my way for the answer. Nice question, learned something new. Don't know if I will be ever using it.

+1.

Easy one. Thanks.

Super easy.