RE: Pivoting Problem" in "Development - SQL Server 2014"

Question

RE: Pivoting Problem" in "Development - SQL Server 2014"

J Livingston SQL

SSC Guru

Points: 51550
More actions
January 31, 2016 at 12:54 pm

#315460

There was a series of posts today, started by "silverbullettruck"
Pivoting Problem" in "Development - SQL Server 2014
for some reason, they have disappeared......one of several email notifications ( as per below) fails to find it.
Confused??
http://www.sqlservercentral.com/Forums/FindPost1757125.aspx
also
http://www.sqlservercentral.com/Forums/FindPost1757142.aspx
http://www.sqlservercentral.com/Forums/FindPost1757144.aspx
Hi J Livingston SQL,
A new reply has been added by silverbullettruck to a topic you're subscribed to.
You can view the reply by clicking the link below...
http://www.sqlservercentral.com/Forums/FindPost1757125.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

Viewing 7 posts - 1 through 7 (of 7 total)

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

Jeff Moden SSC Guru Points: 1004641 More actions · Answer 1

It is my fault. I was deleting SPAM and hit the wrong thread. I've sent an email to the WebMaster asking if he could undelete it.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 2

Jeff Moden (1/31/2016)
It is my fault. I was deleting SPAM and hit the wrong thread. I've sent an email to the WebMaster asking if he could undelete it.

ok...but, if you have permission to delete, then why not permission to undelete?

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

Ed Wagner SSC Guru Points: 287026 More actions · Answer 3

J Livingston SQL (1/31/2016)
Jeff Moden (1/31/2016)
It is my fault. I was deleting SPAM and hit the wrong thread. I've sent an email to the WebMaster asking if he could undelete it.
ok...but, if you have permission to delete, then why not permission to undelete?

You know, that's a good point. Perhaps that's SSMS-only functionality that isn't exposed in the interface?

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 4

The original post appears to be back, but the reply I had already posted is still missing. And so are the two replies posted later (that I did get email notification of but that I never saw).

I hope someone can restore those too. I need to get some sleep, early day tomorrow, so I cannot re-do my earlier reply.

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 5

Hugo Kornelis (1/31/2016)
The original post appears to be back, but the reply I had already posted is still missing. And so are the two replies posted later (that I did get email notification of but that I never saw).
I hope someone can restore those too. I need to get some sleep, early day tomorrow, so I cannot re-do my earlier reply.

snap...plus my reply has been deleted from "my posts"

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

Orlando Colamatteo SSC Guru Points: 182293 More actions · Answer 6

Looks like the OP reposted:

http://www.sqlservercentral.com/Forums/Topic1757179-3412-1.aspx

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato