i thought of two guesses

steve jones == 11 ( total letters including space)

2014 == 7 (all digits added)

but anyways guessing went wrong :crazy:

learnt something new today

Miles Neale (10/17/2014)

---

Sean of the Lynchmob (10/17/2014)

---

I would like to say a huge thank you to the question posters, even when they post the wrong answer. For me personally,...

Gavin Regnart (10/17/2014)

---

Which explains (1) why the query ran without a problem for me, and (2) why there is...

+1

emil.bialobrzeski (10/21/2014)

---

Actually this script WILL work on sql server 2008 because...

After seeing the code , I checked the options for answers, when I saw the option, "display shiva 2 times"

some how I felt this is the answer

By any chance do...

Recently I have used the MERGE statement and answering made it simple.

When I work with CTE, I get this error when I dont give smicolon, so it was easy to answer 🙂

Thanks for the question

Got too hurried up... did not even see "choose 2" :w00t:

frankly, the answer is straight forward as "one" ,but I unnecessarily over looked into the question and thought, author mentioned "single pivot", so I thought using unions we can use...

Hany Helmy (8/6/2014)

---

Easy, another fast way (but maybe not the fastest), just highlight the table then press Alt + F1 will give you all table structure, definition, columns names, data...

Learnt something new today 🙂

I am surprised to know that such a simple QOTD "FROM Hugo" !!! :w00t:

+1

For me, the file got created ONLY when I tried creating the table (not temp table)

and...