How to make CREATE OR REPLACE VIEW work in SQL Server?
SQL Server equivalent to Oracle's CREATE OR REPLACE VIEW
I am able to produce a standard length \sim with a tiny S above it, but I would like the \sim tilde to be longer (maybe one and half times as wide as a capital letter).  Any tips on how to change the width/length of \sim? If H is a subgroup of G ( | G:H |=n, n > 1), then how can you show that G has a factor group G/N which is isomorphic to a subgroup D of the symmetric group Sn with |D| > 1.  I've been looking at Cayley's Theorem but it's not specific to the factor groups. Python: using a recursive algorithm as a generator How to split strings into text and number? How do I send a file with FileZilla from the command line? I have a batch file that builds an application, and then I want to upload it to an FTP server from the command line.   Considering I do the upload manually with , is there a command line for it to upload files?  I am limited to Windows. Present continuous and simple future Why $\sqrt{-1 \cdot {-1}} \neq \sqrt{-1}^2$? I know there must be something unmathematical in the following but I don't know where it is: \begin{align} \sqrt{-1} &amp;= i \\\\\ \frac1{\sqrt{-1}} &amp;= \frac1i \\\\  \frac{\sqrt1}{\sqrt{-1}} &amp;= \frac1i \\\\  \sqrt{\frac1{-1}} &amp;= \frac1i \\\\  \sqrt{\frac{-1}1} &amp;= \frac1i \\\\  \sqrt{-1} &amp;= \frac1i \\\\  i &amp;= \frac1i \\\\  i^2 &amp;= 1 \\\\  -1 &amp;= 1 \quad !!? \end{align} SQL - Stored Procedure with Select Statement using IN (@Variable_CommaDelimitedListOfIDS) TexMaker - "File not found" when viewing as pdf At the moment I'm having a problem when trying to view my LaTeX file as a PDF. Whether I do it internal or external I both the error "File not found.".  I have no idea what file it means. I've read somewhere it has to with my Acrobat Reader, but I still can't get it fixed. And I think it's worth mentioning that I work on Windows 7, as I've also read that Texmaker on Windows has some bugs.  Any help will be appreciated! So people have had similar problems showing colors on .ply files  and   but I don't think this is the same case.  I've exported a .ply file from a program called paraview with color info on it.  I've uploaded the file  and as you can see, the color info came with it.  But for whatever reason when I import it into blender and go look for the per-vertex color info where I would expect to find it, its empty:   Am I doing something wrong?  It seems like there had been a problem with impo but this is 2.81.  I would assume it was fixed? How to get my software into Ubuntu? How to write (La)TeX (with parentheses) [or any other TeX-related logo] Will my device work with Ubuntu? How to create an OD road distance matrix in QGIS? I'm looking for the steps required to produce an origin-destination (OD) cost matrix.  What I'm looking for is a matrix of road distances. The distance matrix tool only produces euclidian distances. The QGIS Roadgraph plugin produces the shortest road distance from one origin to N destinations. What I need is a file containing distances from all origins to the N closest destinations. I have a lot of origins so repeating the analyses with Roadgraph is not an option. Thanks again.  I'm looking for a step-by-step description, starting from scratch (ie, with my 3 shapefiles: origins, destinations, road network). Let $X, Y$ be independent standard normal random variables.  We already know that $X+Y$ is normal with mean 0 and variance 2. However, I am trying to prove this result in a slightly different way than usual, i.e., using convolutions.  We can address the problem in the following way: the sum of the two variables has a density $h(x)$ given by the convolution product of the densities of the two variables, say $f$ and $g$, so that   $$ h(x) = \int_{-\infty}^{\infty} f(x-y)g(y)dy. $$  However,  $$ f(y) = g(y) = \frac{1}{\sqrt {2\pi}}\exp(-y^2/2). $$  Hence now the integral becomes:  $$ h(x) =\frac{1}{2\pi}\int_{-\infty}^{\infty}\exp(-(x-y)^2/2)\exp(-y^2/2)dy. $$  However, I am puzzled here. How should we go on from here? I cannot see how to transform this integral into the integral of a normal r.v of type $N(0,2)$. Thanks in advance for your help. Why is uniform prior on log(x) equal to 1/x prior on x? I'm trying to understand Jeffreys prior. One application is for 'scale' variables like the standard deviation $\sigma$ (or its square, the variance $\sigma^2$) of Gaussian distributions. It is often said that using a uniform prior over $\sigma$ is not really non-informative and instead one should either:   Use instead $\ln \sigma$ as the free parameter, with a uniform prior (this is often called a log-uniform prior) Or keep using $\sigma$ as the free parameter but use $1/\sigma$ as the prior (which is not uniform).   Why are the above two methods/priors equivalent? I feel it has something to do with the fact that the derivative of ln $\sigma$ is $1/\sigma$ but I can't take the next step.   Also, why does this even matter, in simple language with minimal jargon? I see all these complicated explanations online involving the Fisher information matrix but in the end all I see is that the above log-uniform or $1/\sigma$ priors preferentially weight lower values of $\sigma$ more highly. Why? If possible, a simple analytic example or python snippet would be very helpful. Flight Search from anywhere to a specific destination Many flight search engines allow you to pick a departure airport and search for flights to anywhere. E.g.  gives you a nice map with prices next to destinations for a set of dates and an origin you selected. We covered this question widely in  here on our site.  I want to have the reverse, i.e. I know my dates and my destination (for a one-way flight) and I want to know from where it is cheapest to fly there. Is there any flight search engine out there to achieve this?  Google flights does not do this, they pre-compile the "from"-field if I try to leave it empty. I know I could use  with a wide range of departure airports but that does not give me low-cost carriers and I do not trust the matrix results for such a wide range of parameters anymore.  Edit: It has been asked in comments why I would want such a feature. Well currently I'm planning my summer vacation and I would like to spend one week traveling around basically anywhere in that area before I have to go to a specific location at a specific time. One of the main price and convenience factors for me is that final flight so I would like to optimize it first. I'm sure I'm not the only one with that kind of constraints. finding examples for a non negative and continuous function for which the infinite integral is finite but the limit at infinity doesn't exist Question:  a. Find an example for a non-negative and continuous function s.t. $\int _0^\infty f(x)dx$ is finite but the following limit doesn't exist: $\lim_{x\to \infty} f(x)$.  b. Is it possible that $\int _0^\infty f(x)dx$ is bounded but $f(x)$ is not bounded?  What we did with A: We suggested the function $|sin(x^2)|$ which has periods that get smaller and smaller until they no longer imply on the sum. But since it's a trig function it doesn't have a determinate limit. Wolfram didn't have the integral value for that func, and we were wondering if it really converges and if it is really a good example.  What we did with B: We thought about the function: $f(x)=  { x\in \Bbb N },{e^{-x} \notin \Bbb N }$ and we had a disagreement whether f(x) is integrable. I said no because similarly to Dirichlet function, one sum's limit will be 0 while the other one's will be infinite. My partner said that if I find a $\delta&lt;1$ then the definition of Riemann's integral does hold and so this integral is equal to that of $f(x)=e^{-x}$ She was trying to say this functions integral will be 0, but still it won't be bounded. I disagreed. Who's right? Where can I find 32-bit version of Ubuntu? I need to find the 32-bit version, and all I keep finding is the 64-bit. Can anyone provide me with a link? How can I '\input' a file without getting the implicit newline?