I have this table:  Name    Address                  Code James   CT                       Homeaddress Mark    mark@goole.com           Email John    John@hotmail.com         homeemail ...   This is what I want:   Name        Homeaddress      Email           homeemail james       CT mark                         mark@google.com john                                         John@hotmail.com   I am creating a view and dont have privilages to alter the base tables. I was thinking maybe an IF statement might help
I have a SQL Server instance that has a linked server to an Oracle server. There is a table on the Oracle server called PersonOptions which contains the following data:  ╔══════════╦══════════╗ ║ PersonID ║ OptionID ║ ╠══════════╬══════════╣ ║        1 ║ A        ║ ║        1 ║ B        ║ ║        2 ║ C        ║ ║        3 ║ B        ║ ║        4 ║ A        ║ ║        4 ║ C        ║ ╚══════════╩══════════╝   I need to pivot that data so the results are:  ╔══════════╦═════════╦══════════╦══════════╗ ║ PersonID ║ OptionA ║ Option B ║ Option C ║ ╠══════════╬═════════╬══════════╬══════════╣ ║        1 ║       1 ║        1 ║          ║ ║        2 ║         ║          ║        1 ║ ║        3 ║         ║        1 ║          ║ ║        4 ║       1 ║          ║        1 ║ ╚══════════╩═════════╩══════════╩══════════╝   Any suggestions?
How do I set up shared folders in a Windows Virtualbox guest? I have installed VirtualBox OSE on Ubuntu 11.04 and Windows XP pro as the virtual machine. Now I want to have a shared folder which can be accessed on both, my host Ubuntu machine, and my WinXP guest virtual machine.  How can I do that? A question about the arctangent addition formula. In the arctangent formula, we have that:  $$\arctan{u}+\arctan{v}=\arctan\left(\frac{u+v}{1-uv}\right)$$  however, only for $uv&lt;1$. My question is: where does this condition come from? The situation is obvious for $uv=1$, but why the inequality?  One of the possibilities I considered was as following: the arctangent addition formula is derived from the formula:  $$\tan\left(\alpha+\beta\right)=\frac{\tan{\alpha}+\tan{\beta}}{1-\tan{\alpha}\tan{\beta}}.$$  Hence, if we put $u=\tan{\alpha}$ and $v=\tan{\beta}$ (which we do in order to obtain the arctangent addition formula from the one above), the condition that $uv&lt;1$ would mean $\tan\alpha\tan\beta&lt;1$, which, in turn, would imply (thought I am NOT sure about this), that $-\pi/2&lt;\alpha+\beta&lt;\pi/2$, i.e. that we have to stay in the same period of tangent.  However, even if the above were true, I still do not see why we have to stay in the same period of tangent for the formula for $\tan(\alpha+\beta)$ to hold. I would be thankful for a thorough explanation. How to install PostgreSQL 9.2 with PostGIS 2.0 on Ubuntu 11.10 (or higher)? The title says it all. I want to resize windows with an right click while holding the alt key, instead of the new default alt+middle click.  I have found no way to enable this behaviour in 13.04. The gconf-Key suggested in this , doesn't seem to exist any longer. Searching for questions that have ONLY a given tag (i.e. add a range operator for tags) How to change the Play Store language? Keeping the time stamp when syncing with Ubuntu One? Badge progress reports Is there a way to view your own progress towards certain badges? For example:   Tumbleweed - What value constitutes low views for a week? Fanatic  – Is there a way to view how many days in a row you currently have? Beta – Is it even possible to get this badge anymore? how do I get my code to use the value of the $HOME variable? I'm trying to put together a generic script that will check the existence of several key directories for various users on different servers. Additionally, I want to leverage each user's $HOME variable.  For eg, let's say this were true:   on server 1: jdoe's home is /home/jdoe  on server 2: jdoe's home is /opt/jdoe2 server 3 hasn't been built yet; we won't know where they build his $HOME until the server is built. on server 4: mysql's home is /opt/home/mysql   This is what I have for my important directories (ordered from most to least impt):  $ cat mylist.txt $HOME/most_impt_dir1 $HOME/most_impt_dir2 $HOME/most_impt_dir3 $HOME/misc $HOME/junk   ...I want to find the most impt dir owned by this user.   Here's what I'm trying:  for i in `cat mylist.txt` do    if [[ -O $i ]] &amp;&amp; [[ -d $i ]]; then     echo "found it: $i"     break   else     echo "$i is not it."   fi  done   The above code does not work for anything in my list because it is literally checking for dirs beginning with $HOME. How do I get my code to use the value of the user's $HOME variable? Restrictive vs Non-restrictive Relative Clause What approach should I take to establish this logical proof? I need to design a logical math proof:  Write a detailed structured proof to prove that if m and n are integers, then either 4 divides mn or else 4 does not divide n.   Hint: Think about the form of the statement.   I was thinking about first proving that either 4 should divide m or n in order for the first part to be true, then use proof by cases to prove what happened when m was 4, and another case when n was 4...  But I got stuck, what do you recommend:    This is what I got so far: Claim: (m ∈ Z ∧ n ∈ Z) => (4 | mn ˅ 4 ∤ n)  Negated claim: (m ∈ z ∧ n ∈ z) ∧ ( P(n) ∧ ¬P(mn) )  Proof by contradiction  Assume m , n ∈ z:    Assume P(n) ∧ ¬P(mn):       Then ∃ q ∈ R, n = 4q       Let q0 be such that n = 4q0       Then mn = m(4q0)       Then mn = 4(mq0)       Then ∃ q ∈ R, mn = 4q        Then 4 | mn     Then P(n) ∧ P(mn) Then (m , n ∈ z) ∧ P(n) ∧ P(mn))    I know that is wrong, how can I fix it? Definable real numbers I'm an idiot, I was writing an image to a USB drive using dd when instead of typing /dev/sdb I typed /dev/sdd and wrote the 135mb image to my 750gb External Hardrive full of files. Is there ANY possibility of recovering the files or did dd completely zero out the drive? Please help, as this is one of the lowest points of my life EVER.  dd finished writing the 135mb image in 5 seconds, so I didn't have a chance to stop it. By the time I knew what happened to was too late. The command was as follows:   sudo dd if=generic.img of=/dev/sdd bs=1M   EDIT2: The External Harddrive's filesystem was FAT32(I've had the drive for awhile and FAT32 was the most Universal FS at the time). I also have a 2TB drive I just got which I was planning on moving most of the files to from the 750gb, If needed I can use it to transfer the Recovered files to. How do I clear Bash's cache of paths to executables? When I execute a program without specifying the full path to the executable, and Bash must search the directories in $PATH to find the binary, it seems that Bash remembers the path in some sort of cache. For example, I installed a build of Subversion from source to /usr/local, then typed svnsync help at the Bash prompt. Bash located the binary /usr/local/bin/svnsync for "svnsync" and executed it. Then when I deleted the installation of Subversion in /usr/local and re-ran svnsync help, Bash responds:  bash: /usr/local/bin/svnsync: No such file or directory   But, when I start a new instance of Bash, it finds and executes /usr/bin/svnsync.  How do I clear the cache of paths to executables? I'm just going to throw this out there, but Google indexes Stack Overflow really quickly Mental estimate for tangent of an angle (from $0$ to $90$ degrees) Does anyone know of a way to estimate the tangent of an angle in their head? Accuracy is not critically important, but within $5%$ percent would probably be good, 10% may be acceptable.  I can estimate sines and cosines quite well, but I consider division of/by arbitrary values to be too complex for this task. Multiplication of a few values is generally acceptable, and addition and subtraction are fine.  My angles are in degrees, and I prefer not have to mentally convert to radians, though I can if necessary. Also, all angles I'm concerned with are in the range of [0, 90 degrees].  I am also interested in estimating arc tangent under the same conditions, to within about 5-degrees would be good.  Backstory  I'm working on estimating the path of the sun across the sky. I can estimate the declination pretty easily, but now I want to estimate the amount of daylight on any given day and latitude. I've got it down to the arc cosine of the product of two tangents, but resolving the two tangents is now my sticking point. I also want to calculate the altitude of the sun for any time of day, day of the year, and latitude, which I have down to just an arc tangent. I want to sort in-text citations by year, but bibliography by name. It sound exactly like .  However, suggested solution (using \usepackage[sorting=ynt]{biblatex} and \printbibliography[sorting=nty]) does not work for me (see MWEB below). Indeed, the list of references remains year-sorted instead of name sorted.  Question: How to force sorting=nty in \printbibliography?      \documentclass{article}     \usepackage[%         backend=biber,%         style=authoryear-comp,%         natbib=true,%         sorting=ynt%     ]{biblatex}     \addbibresource{\jobname.bib}     \usepackage{filecontents}  \begin{filecontents}{\jobname.bib}     @book{key2000,       author = {Author, A.},       year = {2000},       title = {Alphabetical fist \&amp; Year last},       publisher = {Publisher},     }     @book{key1900,         author = {Boathor, B.},         year = {1900},         title = {Alphabetical last \&amp; Year first},         publisher = {Publisher}, } \end{filecontents}  \begin{document}     Citation should be year-sorted, even if \verb+\citep+ is random \citep{key2000, key1900}.% citation NOT year-sorted      \printbibliography[sorting=nyt] \end{document}   P.S.: At the opposite, using  \begingroup     \newrefcontext[sorting=nyt]     \printbibliography \endgroup    overrides the \usepackage[sorting=ynt]{biblatex} option (i.e. LoR is name-sorted, but in-line citations as well). Call marker color in Geojson to apply to leaflet.js in php How do I copy Word tables into Excel without splitting cells into multiple rows? I have data in a Word table that includes line and paragraph breaks. When I copy the data into Excel, it splits each line and paragraph I want into multiple cells. How do I copy the data to Excel and keep the breaks? How can I hibernate or sleep my Ubuntu 10.10 desktop and have it "wake up" the next day?  I have seen software that can do this on windows, so it can't be hard on Ubuntu!