Need help to pivot one column into rows in SQL Server 2012 - no aggregates and no label column exists
Simulating group_concat MySQL function in Microsoft SQL Server 2005?
After I read that companions don't drain the fusion core of a Power Armor when wearing it, I decided to try giving my armor to Nick so I'll always have it close by if I need it.  But I was wondering if there are any other drawbacks to that. For example, does the Armor get damaged or destroyed when the companion is under fire? It has been a while since I read the Lord of the Rings novels (don't have a copy at the moment) but I seem to recall he went to Hobbiton at least once, as the young hobbits were always excited to see him.   Did he travel there often? How do I combine standard deviations of two groups? I have 2 groups of people. I'm working with the data about their age. I know the means, the standard deviations and the number of people. I don't know the data of each person in the groups.  Group 1 :  Mean = 35 years old; SD = 14; n = 137 people  Group 2 :  Mean = 31 years old; SD = 11; n = 112 people  I want to combine those 2 groups to obtain a new mean and SD. It's easy for the mean, but is it possible for the SD? I do not know the distribution of those samples, and I can't assume those are normal distributions. Is there a formula for distributions that aren't necessarily normal? Python interpreter error, x takes no arguments (1 given) How to create this curved 90-degree-angle quickly I recently saw a lecturer prove the following theorem (assuming the result that every analytic function is locally 1-1 whenever its derivative is nonzero): Let $\Omega \subset \mathbb{C}$ be open, and let $f : \Omega \to \mathbb{C}$ be 1-1 and analytic on $\Omega$.  Then $f&#39;(z_0) \not = 0$ for every $z_0 \in \Omega$.  I got the basic idea behind the proof: we assume for contradiction that $f&#39;(z_0) = 0$, and, assuming without loss of generality that $z_0 = f(z_0) =0$, we have (from the power-series expansion) that $f(z) = z^kg(z)$ for some analytic $g$ in some disk at the origin (i.e., $z_0$) and some $k \ge 2$. Since $z^k$ is not 1-1 in any such disk (because there are multiple roots of unity), then $f$ isn't either.  However, the proof he gave was rather awkward and technical- it involved defining three different axillary functions, even though the idea was simple, and I've since forgotten how it exactly worked.  In any case, I'm convinced there's a better way.  The problem is that I'm having trouble turning the idea into a real proof- I know that it obviously follows if $g$ is 1-1, but I'm also pretty sure that that is too strong an assumption.  Am I missing something, or does the argument just have to be more complicated? Referencing the reference? apt-get stuck at 0 [Connecting to us.archive.ubuntu.com] When I do upgrade it gets stuck here:  user@plato:~# sudo apt-get upgrade Reading package lists... Done Building dependency tree        Reading state information... Done Calculating upgrade... Done The following packages will be upgraded:   bind9-host coreutils cpio curl dnsutils libbind9-90 libc-bin libc-dev-bin   libc6 libc6-dev libcgmanager0 libcurl3 libcurl3-gnutls libdns100   libdrm-intel1 libdrm-nouveau2 libdrm-radeon1 libdrm2 libisc95 libisccc90   libisccfg90 libjasper1 liblwres90 libplymouth2 libsepol1 libssl-dev   libssl-doc libssl1.0.0 linux-libc-dev mime-support multiarch-support ntp   ntpdate openssl plymouth plymouth-theme-ubuntu-text python3-distupgrade   ubuntu-release-upgrader-core unzip 39 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. Need to get 16.0 MB of archives. After this operation, 12.3 kB of additional disk space will be used. Do you want to continue? [Y/n] y 0% [Connecting to us.archive.ubuntu.com (2001:67c:1562::15)] ░   When I do update it gets stuck here:  user@plato:~# apt-get update 0% [Connecting to us.archive.ubuntu.com (2001:67c:1562::14)] [Connecting to sec░   I'm able to ping us.archive.ubuntu.com just fine:  user@plato:~# ping us.archive.ubuntu.com PING us.archive.ubuntu.com (91.189.91.23) 56(84) bytes of data. 64 bytes from economy.canonical.com (91.189.91.23): icmp_seq=1 ttl=54 time=81.5 ms 64 bytes from economy.canonical.com (91.189.91.23): icmp_seq=2 ttl=54 time=81.5 ms 64 bytes from economy.canonical.com (91.189.91.23): icmp_seq=3 ttl=54 time=81.5 ms 64 bytes from economy.canonical.com (91.189.91.23): icmp_seq=4 ttl=54 time=81.4 ms ^C --- us.archive.ubuntu.com ping statistics --- 4 packets transmitted, 4 received, 0% packet loss, time 3004ms rtt min/avg/max/mdev = 81.425/81.528/81.582/0.355 ms   What can i do to fix this?    What I have tried so far.  I've tried following directions on this blog:   To force apt-get to use IPv4 exclusively   Create a file in /etc/apt/apt.conf.d/99force-ipv4 Add this line to newly created file Acquire::ForceIPv4 false; Apt-get will now use IPv4 exclusively Give warning when [super method] is not called What can I do to manage my phone's internal storage? If you're not used to seeing the 'low on internal storage' notification, what is it that you're doing to keep your phone's internal memory from filling up so quickly?   The 'SD Card and Phone Storage' menu in the settings doesn't really tell me much other than how much is free. And, I don't really have that many applications installed. The top 5 storage hogging apps on my phone are Gmail (18.6 MB), Twitter (17.5 MB), Facebook (12.55 MB), Maps (9.63 MB), and Swype (6.06 MB).  So, are there apps out there (besides your normal file manager ones, like Astro) that will help monitor internal phone storage? Is there something I should be doing to keep my phone storage use to a minimum? What is the minimum $ \sigma$-algebra that contains open intervals with rational endpoints What are the minimum $\sigma$-ring and $\sigma$-algebra on $\mathbb R$ which contain the open intervals with rational endpoints?  Is there a relation between this $\sigma$-algebra and Borels? How to apply multiple styles in WPF In WPF, how would I apply multiple styles to a FrameworkElement?  For instance, I have a control which already has a style.  I also have a separate style which I would like to add to it without blowing away the first one.  The styles have different TargetTypes, so I can't just extend one with the other. Describing groups with given presentation? $\langle x,y\ |\ xy=yx,x^5=y^3\rangle$ and $\langle x,y\ |\ xy=yx,x^4=y^2\rangle$. I'm trying to describe the groups with presentations $\langle x,y\ |\ xy=yx,x^5=y^3\rangle$ and $\langle x,y\ |\ xy=yx,x^4=y^2\rangle$. I have some problems getting a good picture of what they look like...   For the first one, $xy=yx$ allows us to say that any element in the group can be written as $x^iy^j$ for some $i,j$. More precisely, using $x^5=y^3$, we can always reduce $j$ to $0,1$ or $2$, whereas $i$ could have any value. So I was thinking about $\mathbb{Z} \times C_3$. But the other way around (reducing $i$ this time) it's also $C_5 \times \mathbb{Z}$. But then I should be able to prove that both descriptions are equivalent, which I can't do...  For the second, I proceed similarly and get to the same kind of problem...  Could you tell me where I'm going wrong?  Thank you very much in advance! I recently changed my username to Undo. I was amazed when I pressed Submit and saw that it actually went through - surely someone somewhere was using this same username.  Out of curiosity, I then search the SO user list for Undo - and found  with Undo as thier name. They have 50 rep. I have around 1,500.   Is there some kind of pecking order, I.e. a high-rep user can 'steal' a low-rep user's name? Or is this a bug?  Or can two users have the same username without causing the SO servers to go down in a burning ring of fire? What is a "hat"? What exactly is a hat?  I have seen a lot of people arguing the significance of hats and the limited edition hats. I know the hats are sort of linked to the Winterbash stuff, but what exactly is a hat, what does it do, how do I get one?  Is there a full list of hats? In Revenge of the Sith, we learn that Anakin's final seduction to the Dark Side occurs because of his obsession with power and especially his obsession with the power to cheat death to save Padme.       PALPATINE: Only through me can you achieve a power greater than any Jedi. Learn to know the dark side of the Force, Anakin, and you will be able to save your wife from certain death.   (Note, save your wife from certain death, not resurrect)  This obsession is motivated by Anakin's repeated visions of Padme's death during childbirth.   Also, we have     PALPATINE: To cheat death is a power only one has achieved, but if we work together, I know we can discover the secret.   Yet when Padme confronts Anakin on Mustafar, and then Luke and Leia are born, they are full term or close to it.   So how did Anakin think this would help?   Did he expect to figure out this power with Sidious in a matter of days or weeks? Adding a comment should not make me fail the review audit I would like to install the restricted extras package, which I didn't select during the install. How can I do that?        is a meta-package that installs:         Support for MP3 and unencrypted DVD playback   Microsoft TrueType core fonts   Flash plugin   codecs for common audio and video files How can one cite theorems of references? Prove that $A^TD-C^TB=I$