Unpivot

Question

Unpivot

Umer Akram

SSC-Insane

Points: 22209
More actions
October 15, 2014 at 10:33 pm

#397511

Comments posted to this topic are about the item Unpivot

Viewing 15 posts - 1 through 15 (of 64 total)

You must be logged in to reply to this topic. Login to reply

Vimal Lohani SSCommitted Points: 1650 More actions · Answer 1

twin.devil (10/15/2014)
Comments posted to this topic are about the item <A HREF="/questions/unpivot/117130/">Unpivot</A>

HAHA,

Still wrong answer

admin has not tested it.

Answer should be two rows.

OrderIDProductNameProductQty
1 GiftCard 1
1 Shipping 3

I think admin should return yesterday and today's points.

Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature

saravanan.a 88885 Ten Centuries Points: 1003 More actions · Answer 2

saravanan.a 88885

Ten Centuries

Points: 1003

October 15, 2014 at 11:14 pm

#1752723

Please see the Query result attachment..........

Mauricio_ SSCrazy Points: 2935 More actions · Answer 3

I get 2 rows as you can see in this link:

It's a bad week for QOTD 🙂

StefanMayer Old Hand Points: 355 More actions · Answer 4

After correcting the spelling mistakes ( if you run this query on a case sensitive instance) you will receive 2 rows!

Vimal Lohani SSCommitted Points: 1650 More actions · Answer 5

StefanMayer (10/16/2014)
After correcting the spelling mistakes ( if you run this query on a case sensitive instance) you will receive 2 rows!

What do you mean by correcting spelling mistakes and case sensitive instance

Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature

Igor Micev SSC-Dedicated Points: 33109 More actions · Answer 6

Vimal Lohani (10/15/2014)
twin.devil (10/15/2014)
Comments posted to this topic are about the item <A HREF="/questions/unpivot/117130/">Unpivot</A>
HAHA,
Still wrong answer
admin has not tested it.
Answer should be two rows.
OrderIDProductNameProductQty
1 GiftCard 1
1 Shipping 3
I think admin should return yesterday and today's points.

Agree. Seems like admin doesn't check the questions.

It went something wrong with the yesterday's and today's QotD answers.

Igor Micev,My blog: www.igormicev.com

Ulysses_Infinity SSCrazy Points: 2588 More actions · Answer 7

Ulysses_Infinity

SSCrazy

Points: 2588

October 16, 2014 at 12:56 am

#1752737

Give me my point !!!!!

Neil Burton SSC-Insane Points: 22999 More actions · Answer 8

The answer is wrong again! As usual, I read the question and decided what my answer would be. I then ran the query and confirmed my answer only to be told that I was wrong when I picked my chosen answer.

I'm not going to complain about missing points because guess what, I've got a point by posting this.

On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 9

*sigh*

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Stuart Davies SSCoach Points: 19505 More actions · Answer 10

Koen Verbeeck (10/16/2014)
*sigh*

Indeed

-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx

serg-52 SSCrazy Eights Points: 9913 More actions · Answer 11

"Besides, null values in the input of UNPIVOT disappear in the output."

Exactly. But it means 2 rows. 😉

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 12

BWFC (10/16/2014)
I'm not going to complain about missing points because guess what, I've got a point by posting this.

Woohoo! 😎

😉

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Maciej Łuszczyński SSC Enthusiast Points: 171 More actions · Answer 13

I'm not going to complain about missing points because guess what, I've got a point by posting this.

Good point 😉 but that won't fix your stats. I would prefer my point back in first place...

StefanMayer Old Hand Points: 355 More actions · Answer 14

I mean the difference of Orderid and OrderID, case sensitive systems think, that there are 2 different variables.