select from doesnt seem to work
MySQL returns only one row
TimeSpan to String causing an error When or why would you use a right outer join instead of left? states:  "In practice, explicit right outer joins are rarely used, since they can always be replaced with left outer joins and provide no additional functionality."  Can anyone provide a situation where they have preferred to use the RIGHT notation, and why? I can't think of a reason to ever use it. To me, it wouldn't ever make things more clear.  Edit: I'm an Oracle veteran making the New Year's Resolution to wean myself from the (+) syntax. I want to do it right Volume calculation of truncated cones with elipses as base and top I wish to calculate the volumes of a truncated cone whith asymetry over all axes and ellipses as base and top - how do I do that?  I have height and radii of the corresponding ellipses. (I assume correctly I need the geometric means of the 2 radii describing the ellipsis.)  Kind Regards Showing that $\frac{\sqrt[n]{n!}}{n}$ $\rightarrow \frac{1}{e}$ Show:$$\lim_{n\to\infty}\frac{\sqrt[n]{n!}}{n}= \frac{1}{e}$$  So I can expand the numerator by geometric mean. Letting $C_{n}=\left(\ln(a_{1})+...+\ln(a_{n})\right)/n$. Let the numerator be called $a_{n}$ and the denominator be $b_{n}$ Is there a way to use this statement so that I could force the original sequence into the form of $1/\left(1+\frac{1}{n}\right)^n$ List View Visibility How do I copyright my website? My website has been in development for a long time and cost a lot of money.  How do I go about securing an enforceable copyright on my website design and what is the proper way to post a copyright notice on the site so others know the work is copyrighted? Derive a formula to find the number of trailing zeroes in $n!$ Possible Duplicate:          I know that I have to find the number of factors of $5$'s, $25$'s, $125$'s etc. in order to do this. But how can you derive such a formula for any number $n$? $\sum_{k=1}^nH_k = (n+1)H_n-n$. Why? Why taking components of a component of a vector is invalid? Is stage.*.example.com valid for a wildcard DNS CNAME? Union of uncountable cardinals How do I create a D&D character correctly as a total newbie? I'm trying to amass a list of physics books with open-source licenses, like Creative Commons, GPL, etc. The books can be about a particular field in physics or about physics  in general.  What are some freely available great physics books on the Internet? edit: I'm aware that there are tons of freely available lecture notes online. Still, it'd be nice to be able to know the best available free resources around.  As a starter:         Table of contents sorted by field (in alphabetical order): gedit: search and replace with regular expressions I want to replace this with gedit:   1299465 |  2003415 | 2015-09-06 05:35:34.59662+02  1299449 |  2009400 | 2015-09-06 05:35:32.301683+02  1299450 |  2008465 | 2015-09-06 05:35:32.451393+02  1299457 |  2015211 | 2015-09-06 05:35:33.451049+02   to that:  2003415 2009400 2008465 2015211   How can I do this with gedit?  Background: I want to do it with gedit and not sed/python/.... since the replace needs to be done interactive. How to test randomness (case in point - Shuffling) First off, this question is ripped out from  question. I did it because I think this part is bigger than a sub-part of a longer question. If it offends, please pardon me.  Assume that you have a algorithm that generates randomness. Now how do you test it? Or to be more direct - Assume you have an algorithm that shuffles a deck of cards, how do you test that it's a perfectly random algorithm?  To add some theory to the problem - A deck of cards can be shuffled in 52! (52 factorial) different ways. Take a deck of cards, shuffle it by hand and write down the order of all cards. What is the probability that you would have gotten exactly that shuffle? Answer: 1 / 52!.  What is the chance that you, after shuffling, will get A, K, Q, J ... of each suit in a sequence? Answer 1 / 52!  So, just shuffling once and looking at the result will give you absolutely no information about your shuffling algorithms randomness. Twice and you have more information, Three even more...  How would you black box test a shuffling algorithm for randomness? How to make a logo where a letter is made of particles of varying sizes? How can I make a logo in Adobe Illustrator like the AntiParticle logo below, from ?   It is a large number circles of different, varying sizes, which form the shape of a text character. In SQL Server 2005, are there any disadvantages to making all character fields nvarchar(MAX) rather than specifying a length explicitly, e.g. nvarchar(255)? (Apart from the obvious one that you aren't able to limit the field length at the database level) Deleting photos on the phone - does it affect them on iCloud? Open subscheme of an irreducible component remains open? Best book of topology for beginner? I am a graduate student of math right now but I was not able to get a topology subject in my undergrad... I just would like to know if you guys know the best one..