Concatenate rows that are part of a group
Simulating group_concat MySQL function in Microsoft SQL Server 2005?
Does Windows 7 allow auto-login with a stored password, like TweakUI did? The TweakUI powertoy for Windows XP had an option to auto-login. It stored your password and did the login for you. This was useful, since you kept password protection, but had login programs loaded when you first booted.  When you switched users or hibernated, it would still ask for a password, which is the desired behavior.  Is there a way of doing this in Windows 7? This is something that I always find a bit hard to explain to others:  Why do XML namespaces exist?  When should we use them and when should we not? What are the common pitfalls when working with namespaces in XML?   Also, how do they relate to XML schemas? Should XSD schemas always be associated with a namespace? What is the need of complex functions in wave analysis? It is commonly known that waves can be express in terms of sine or cosine function. But when I study further, I seen that for analyising the waves, it is common to use complex functions in the form $$y=y_{_0}e^{i(kx-\omega{t})}$$ where $y_{_0}$ is the amplitude, $k$ is the wave number, $\omega$ is the angular velocity and $x$ &amp; $t$ are position an time respectively. Ofcourse, I know that the function $e^{ix}$ can be written in the form $\cos{x}+i\sin{x}$ and so it is a periodic function with period $2\pi$ but my question is for what purpose we define it in terms of complex numbers? It seem to be more convenient to use real functions for real variables such as amplitude, electric and magnetic field of an electro magnetic wave, and also in quantum mechanics. What actually this interpretation means or what is the advantage of such functions? Atheros AR9462 WiFI very unstable & package loss I'm having severe issues w/ package-loss and a generally bad connection w/in a WiFi-network at my uni. I'm usually encountering a package loss of ~50% and aborting connections which makes working w/ SaaS impossible.  I'm using Ubuntu 13.04 and my network-adapter is an Atheros AR9462.  Applying the nohwcrypt=1-option doesn't change anything.  Also very noticable: The connection works as intended in other networks; the problematic network uses WPA2 w/ MSCHAPv2.  Anyone can help my out here?  $ sudo lshw -class network  *-network UNCLAIMED             description: Ethernet controller        product: NetLink BCM57780 Gigabit Ethernet PCIe        vendor: Broadcom Corporation        physical id: 0        bus info: pci@0000:04:00.0        version: 01        width: 64 bits        clock: 33MHz        capabilities: pm msi pciexpress bus_master cap_list        configuration: latency=0        resources: memory:d3500000-d350ffff   *-network        description: Wireless interface        product: AR9462 Wireless Network Adapter        vendor: Atheros Communications Inc.        physical id: 0        bus info: pci@0000:09:00.0        logical name: wlan0        version: 01        serial: e0:06:e6:76:ba:89        width: 64 bits        clock: 33MHz        capabilities: pm msi pciexpress bus_master cap_list rom ethernet physical wireless        configuration: broadcast=yes driver=ath9k driverversion=3.8.0-22-generic firmware=N/A ip=131.173.74.130 latency=0 link=no multicast=yes wireless=IEEE 802.11abgn        resources: irq:19 memory:d3400000-d347ffff memory:9fb00000-9fb0ffff How do I recover the Facebook account password? I have forgotten my Facebook account password and also I have no access to the number which I use to log-in to Facebook account.   On this page (see the image below) they are asking for a government photo-ID to verify my account. The problem is that I don't have a driving license, voter ID card, passport etc. All I have is a school ID card but that hasn't worked for me. Is there any other way to recover my password? Solvability and reducibility of a polynomial in a "chain" of finite fields Can I see a list of gyms I left a pokemon at? Could someone make the proof into a hinted exercise? Let $(c_n)$ be a sequence of positive numbers.  Could someone make the proof of the inequality  $\displaystyle\limsup_{n\to\infty}\sqrt[n]{c_n}\leq\limsup_{n\to\infty}\frac{c_{n+1}}{c_n}$  into a hinted exercise? How do I mirror the faces of a cube (edit all of them when I edit one)? How to replace the domain name in a Wordpress database? I have a Wordpress database which was installed in a development environment... thus, all references to the site itself have a fixed IP address (say 192.168.16.2). Now, I have to migrate that database to a new Wordpress installation on a hosting. The problem is that the SQL dump contains a lot of references to the IP address, and I have to replace it with: my_domain.com.  I could use sed or some other command to change the that from the command line, the problem is that there are a lot of configuration data which uses JSON. So what? Well, as you know, JSON arrays uses things like: s:4: to know how many chars an element has, and thus, if I just replace the IP with the domain name, the configuration files will get corrupted.  I used an app for Windows some years ago that allows to change values in a database and takes care of the JSON arrays. Unfortunately, I forgot the name of the app... so the question is: do you know any app that allows me to do what I want? What item bonuses apply to my follower? There are a lot of different side effects an item can have, and I assume that things like magic find have no influence on any of "our" found items at all.  However, I'm not sure about other things. For example:   Do followers get life-steal on weapons, too? Does increased orb healing make any difference? What about +experience after kills? Will my follower level up faster?   and probably a lot more.  Is there some general rule as to what effects of an item apply to followers, and which don't? Why is $\sqrt{-x}*\sqrt{-x}=-x?$ Conservation of energy and Doppler effect? List of GUI Based Torrent clients $\operatorname{Aut}(\mathbb Z_n)$ is isomorphic to $U_n$. I've tried, but I can't solve the question. Please help me prove that:  $\operatorname{Aut}(\mathbb Z_n)$ is isomorphic to  $U_n$. Find the eigenvector associated with the smallest eigenvalue, not smallest in magnitude Negative pressure Remove association with blank file extension? Internal microphone not working I have an internal microphone in my laptop. I think it uses Intel High Definition Audio. But I can't get it to work with Ubuntu. It doesn't work with either the Sound Recorder or Skype.  On the Input tab in 'Sound Preferences', I just see Internal Analog Input Device... Print composer custom grid label problem In answer to  Klas Karlsson puts forward a solution to the problem of formatting print composer grid labels for projected maps.  I'm very weak on scripting, but in QGIS 2.14 I've tried to enter the text as shown in Klas's illustration, which generates error messages. In my case I'm working with a coordinate system that has a six-digit Easting and a six-digit Northing and I'm trying to get a result similar to that shown in Klas's picture (but with a six-digit Northing). Can anyone help me with this?