Convert column resultset to row SQL Server
Simulating group_concat MySQL function in Microsoft SQL Server 2005?
Here is the problem:  Suppose that $*$ is an associative binary operation on a set $S$. Let  $$H:= \{a \in  S\mid a * x = x * a \mbox{ for all }x\in S\}.$$  In other words, $H$ is consisting of all the elements of $S$ that commute with every element in $S$.  Show that $H$ is closed under $*$. I need to round the edges of this object.  The bottom edges are going to be rounded in conjunction with another object, so, I guess, this should be left out right now.  I tried using the bevel tool (and a bevel modifier) on an edge (series of Blender edges), but I got the problems you see on the images. When selecting all edges, the bevel doesn't know any limit and isn't applied symmetrically.  When selecting only the edges shown (or only the other ones), I can't proceed with the rest of the bevel, and strange little artifacts appear.  FYI: The top surface is derived from an icosphere.    Without the subdivision shown above, a stair comes into existence (bad):    Whole object: Built-in text editor in Terminal Is there a built-in text editor in the terminal on Lion?  (Like, for example, nano on Linux.) How to change the default views of quad view? How do I change the TOP ortho view to BACK ortho view for my BACK image?   check out the pic I uploaded to see what I'm talking about. How can I stop Steam from loading when I start my computer? Every time I boot into OSX or Windows, Steam automatically starts.  Is there a way to stop Steam starting whenever I boot up my computer? How can I respawn the Ender Dragon? It would be easier to ask for a user's password only once during registration.  The problem: The user could make a mistake while typing the password once because of hiding letters.  The solution: The user could have a toggle button for showing or hiding the password.    Working example with . This approach could be used on the registration or login page.   Are there any benefits to asking a user's password twice during registration vs just not masking the password? Why would you ask twice?  P.S. :        Users make more errors when they can't see what they're typing while filling in a form. They therefore feel less confident. This double degradation of the user experience means that people are more likely to give up and never log in to your site at all, leading to lost business. (Or, in the case of intranets, increased support calls.)   The more uncertain users feel about typing passwords, the more likely they are to (a) employ overly simple passwords and/or (b) copy-paste passwords from a file on their computer. Both behaviors lead to a true loss of security.      Update: I created a . So you may use it if you want to.    Update 2: .  Update 3: Internet Explorer 10 added a toggle password visibility icon. It looks like this:    Update 4: Article about .  Update 5: Example with . There are a few "automatically protect questions" requests out there, but I'd like to add another twist.  I'd like to request that questions that have three or more deleted answers by users with &lt;50 rep be automatically protected.  The reasoning behind this is that we have lots and lots of "not an answer" flags in the mod queue.  But we cannot protect a question from the mod queue, so we have to open each answer, evaluate if the question needs protecting, then protect it.    This process takes a long time, and can definitely be automated, as the only thing you really need to check is how many new users are posting non-answers or are spamming their awful products. "GPT detected. Please create a BIOS-Boot partition" while using boot-repair How do I run wireshark, with root-privileges? A standard installation of Wireshark doesn't give the program permission to access the network interface.   I suppose I have to run the program with sudo, but do not know how to add it to the icon - if that's the way to do it. cant install or remove anything on 18.04 cause of DPKG error Anyone know if R has quote-like operators like Perl's qw() for generating character vectors? Is there a way in javascript to detect if the unload event is caused via a refresh, the back button, or closing the browser? Note: The legacy Skype for Linux application (v4.*) is now discontinued and was removed from Canonical’s partner repositories, so this question and its answers are obsolete. Please refer to  of our .    I am receiving the following message while I am trying to install Skype:  nidhin@ubuntu:~$ sudo apt-get update nidhin@ubuntu:~$ sudo apt-get install skype Reading package lists... Done Building dependency tree        Reading state information... Done Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help to resolve the situation:  The following packages have unmet dependencies:  skype : Depends: skype-bin but it is not installable E: Unable to correct problems, you have held broken packages   How can I fix this? When the phrase is used as an object, why so many native speakers are saying "you and I" instead of "you and me"? I'm not a native speaker but I thought "you and me" is correct. Not sure if this falls into the same category, but "Just between you and me" sounds more natural than "Just between you and I". When you have a card like  which reads "Exile Target Creature with power 3 or less", as I understand it, it becomes untargetable if the opponent's creature power increases thanks to a pump spell like .  But what if the Disregard is already on the stack and targeting; and they respond with Brute Strength? I'm pretty sure (and my opponent with Brute Strength was certain) that it won't exile the creature, but I don't know which rule states this, and there's no gatherer ruling on the spell. var/cache/apt/archives occupying huge space I am in the process of cleaning up my system. And I see a lot of space occupied by this folder /var/cache/apt/archives (1.5GB). Is it absolutely necessary to keep all these archives? Why am I getting authentication errors for packages from an Ubuntu repository? I'm experimenting with VPNs, so I wanted to install pptpd.  john@desktop:~$ sudo apt-get install pptpd [sudo] password for john:  &lt;snip&gt; The following extra packages will be installed:   bcrelay The following NEW packages will be installed:   bcrelay pptpd 0 upgraded, 2 newly installed, 0 to remove and 11 not upgraded. Need to get 90.5 kB of archives. After this operation, 442 kB of additional disk space will be used. Do you want to continue [Y/n]? y   And everything runs fine until I get down to here:  WARNING: The following packages cannot be authenticated!   bcrelay pptpd Install these packages without verification [y/N]? n E: Some packages could not be authenticated   No authentication?  I'm no security expert, but I'm fairly sure that's a bad thing.  So I .  john@desktop:~$ apt-cache policy pptpd pptpd:   Installed: (none)   Candidate: 1.3.4-3ubuntu1   Version table:      1.3.4-3ubuntu1 0         500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages john@desktop:~$ apt-cache policy bcrelay bcrelay:   Installed: (none)   Candidate: 1.3.4-3ubuntu1   Version table:      1.3.4-3ubuntu1 0         500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages   They're coming from Ubuntu.com and not being properly authenticated?  What's going on here? Opt in "mentor" privilege at 7.5k I am suggesting a Mentor privilege at 7.5k. It would be on a per-user per-site opt in basis.  At some reputation level (perhaps 7.5k) there could be an opt in "mentor" privilege.  If someone opts in then when a new user signs up, they become their Mentor. The new user is the Mentee.  They will get notified of any posts or suggested edits they make, and can help and support them.  While this would by no means help everyone (I'm sure there are more new people signing up than there are 7.5k people willing to help them), it could help mitigate the "new user's bad posts" and such like.  By no means would being someone's mentor mean you are the only person who can edit and help them, and you aren't obliged to do so - but if you have opted in then you should help.  How would this work?   Any Mentor would have no more than 5 active Mentees at once. Once the Mentee gets to 125 rep, the downvote privilege (or any other level deemed sensible) they are no longer a Mentee. If they aren't active for a month, they are no longer a Mentee. If the Mentor has 5 Mentees (i.e. cannot mentor anyone else) then any Mentee not active for 2 weeks is no longer a Mentee. The Mentee can opt out at any time, the Mentor can opt out, but if they opt out a lot (say 5 people in 2 months) they are blocked from the privilege for 2 weeks. The Mentor gets no extra rep. They can still get rep from answering their Mentee's questions and similar. Once the new user gets 20 rep on the site, a chat room is created for them to talk. No user with the association bonus will become a Mentee. This would (maybe) be opt in for sites. For example, this might not be at all useful for this site, or for , but on  or  I imagine this could be quite good.    appears to be asking the same thing, based on the title, but that is asking about people who know each other offline mentoring each other.    Every single one of these suggestions (especially the numbers) is open to discussion. Maybe 125 is to low to stop being mentored, or maybe it's too high. What do you think? Foobar2000-like music player?