Combine data in cell using SQL Server
Simulating group_concat MySQL function in Microsoft SQL Server 2005?
Reopened questions get a "modified" time stamp in the questions list just showed up on 's front page like this:    ... which makes no sense, because the question hasn't been modified since May 25th, and the person who edited it wasn't CatLord anyway:    Turns out what actually happened was that CatLord cast a fifth reopen vote to reopen the question.    So that stamp in the questions list should probably say this instead:     reopened 4m ago CatLord 10.7k   Or just:     reopened 4m ago The tag  and meta-tag  syntax generate much nicer looking results than merely surrounding your tag with [square brackets].    However, they only work when you're talking about the site you're on.  On Area51, in Chat, and on Meta sites, this is frequently not the case, leading to attempts at syntax like [[tag:failure]](https://superuser.com/questions/tagged/failure), which produces:    Hmm, must be some subtle syntax thing:   : [tag:failure](https://superuser.com/questions/tagged/failure) []: [[tag:failure](https://superuser.com/questions/tagged/failure)] : [tag:[failure]((https://superuser.com/questions/tagged/failure))] : &lt;a href="https://superuser.com/questions/tagged/failure"&gt;[tag:failure]&lt;/a&gt; : [tag:failure][1] \n\n [1]: https://superuser.com/questions/tagged/failure : [more text is a [tag:failure] too](https://superuser.com/questions/tagged/failure)   I give up!  How can I create a link to a tag on another site with tag markdown? I have sucessfully installed AniMove by activating experimental plugins (yay! thanks gis.stackexchange). But I can't find it in Qgis! Yes I have activated it. Where is it? Is this a common bug? I searched for it the toolbox, I looked up the names of the several single tools based on this  and only found "Kernel Density", which is filed under SAGA. But I don't have SAGA installed (and don't know if I need to?) Does payment in goods count as "income" for tax purposes? Can someone help me elucidate the definition of "income" from a tax perspective? More specifically, if Joe is paid for his work in avocados instead of dollars, then would Joe be exempt from paying any income tax for the year? Or would the value of avocados earned for the year be translated into dollars which would then be considered Joe's annual income? If so, what guidelines would one use to make this translation? (Make the assumption that Joe does not sell the avocados (for dollars) at a later date and either eats them or trades them for other real property)  What if he was paid in gold instead of avocados? How to study/prepare for the Salesforce Developer Certification I am fairly new to Force.com development (less than a year). I did not learn it from the ground up. So I think it will be good to study for the developer exam to strengthen my basics and improve my overall knowledge of Force.com + it will be great to have this certification.  Now it's surprising that there is not a lot of great information on the web about how to go about obtaining this certification. Most other major certifications have dedicated study guide books available but there are few for Force.com and I don't think any of them are official.   The official page has little information. The Study guide gives a broad description of the topics in the test.   I see a lot of the esteemed members are here certified developers. I think if you guys could give us a little information, hints/tips and some advice on how to prepare for this exam, it will really be of great help. Also is DEV401 required/helpful?  Also if we could get recommendations for great resources(books, online training etc) and practice tests it will be awesome. Disable cache for some images Export each image from a collection in Google Earth Engine I am trying to export each image in a filtered stack of Sentinel-1 images and cannot seem to get it right.   suggests using imageCollection.map() and a custom function (such as a geometric clip).  // Create a geometry representing an export region. var roi = ee.Geometry.Rectangle([-63.0, 9.2, -63.1, 9.3]);   // Load the Sentinel-1 ImageCollection. var sentinel1 = ee.ImageCollection('COPERNICUS/S1_GRD');   // Filter by metadata properties. var IW_H = sentinel1   // Filter to get images with VV and VH dual polarization.   .filter(ee.Filter.listContains('transmitterReceiverPolarisation', 'VV'))   .filter(ee.Filter.listContains('transmitterReceiverPolarisation', 'VH'))   // Filter to get images collected in interferometric wide swath mode.   .filter(ee.Filter.eq('instrumentMode', 'IW'))   // Filter IWs to get High res.   .filter(ee.Filter.eq('resolution', 'H'))   // Filter IW-Highs to get 10m res   .filter(ee.Filter.eq('resolution_meters', 10));   // Filter to get images from different look angles  var DescCollection = IW_H.filter(ee.Filter.eq('orbitProperties_pass', 'DESCENDING'));   var ClipFunc = function(iImage, geom) {   var iClip = clip(iImage, geom);   return(iClip); };   imageCollection.map(ClipFunc(DescCollection, roi)); Eigenvectors of real symmetric matrices are orthogonal Can someone point me to a paper, or show here, why symmetric matrices have orthogonal eigenvectors? In particular, I'd like to see proof that for a symmetric matrix $A$ there exists decomposition $A = Q\Lambda Q^{-1} = Q\Lambda Q^{T}$ where $\Lambda$ is diagonal. Can I ignore coefficients for non-significant levels of factors in a linear model? After seeking clarification about linear model coefficients  I have a follow up question concerning non-signficant (high p value) for coefficients of factor levels.  Example: If my linear model includes a factor with 10 levels, and only 3 of those levels have significant p values associated with them, when using the model to predict Y can I choose to not include the coefficient term if the subject falls in one of the non-signficant level?  More drastically, would it be wrong to lump the 7 non-significant levels into one level and re-analyze? I need to show the following: $$\lim_{k\rightarrow \infty} \left(1 + \frac{z}{k}\right)^k=e^z$$  For all complex numbers z. I don't know how to start this. Should I use l'Hopitals rule somehow? So, I have proven already that every open set in $\mathbb{R}$ can be written as a countable union of disjoint open intervals; i.e., that $\mathcal{O} = \bigcup_{i=1}^\infty (a_{x_i}, b_{x_i})$.  Now, consider the closed interval $\left [ a + \frac{1}{n}, b - \frac{1}{n}\right ] \subset (a, b)$.  Since the midpoint of $(a,b)$ is $\frac{b-a}{2}$, we need $\displaystyle n &gt; \frac{2}{b-a}$.  Otherwise, $\displaystyle a + \frac{b-a}{2} = a + \frac{1}{ \frac{2}{b-a}} = b - \frac{1}{ \frac{2}{b-a}} = b - \frac{b-a}{2}$, and our interval will be degenerate.  Note that $\forall (a,b) \in \mathcal{O}$,   $\displaystyle \bigcup_{n = \frac{b-a}{2}+1}^{\infty} \left[ a + \frac{1}{n}, b - \frac{1}{n} \right] = (a,b)$.  So, we have $\displaystyle \mathcal{O} = \bigcup_{i=1}^\infty \left ( \bigcup_{n = \frac{b-a}{2} + 1}^\infty \left[ a_{x_i}+\frac{1}{n}, b_{x_i}-\frac{1}{n} \right] \right)$.  But, I don't like this. It looks like I'm still just taking a union of open sets.  Please help me get this to look like the union of closed sets.  (For unbounded intervals, I know what to do - it should follow from this relatively easily). Solve $\lim_{x\to 0} \frac{\sin x-x}{x^3}$ I'm trying to solve this limit     $$\lim_{x\to 0} \frac{\sin x-x}{x^3}$$   Solving using L'hopital rule, we have:  $$\lim_{x\to 0} \frac{\sin x-x}{x^3}= \lim_{x\to 0} \frac{\cos x-1}{3x^2}=\lim_{x\to 0} \frac{-\sin x}{6x}=\lim_{x\to 0} \frac{-\cos x}{6}=-\frac{1}{6}.$$  Am I right?  I'm trying to solve this using change of variables, I need help.  Thanks  EDIT  I didn't understand the answer and the commentaries, I'm looking for an answer using change of variables. states that the relationship between current ( I ) voltage ( V ) and resistance ( R ) is  $$I = \frac{V}{R}$$  However  cause the resistance of a material to go to zero, and as I understand it, as $R \to 0$, $I \to \infty$. Does this present a problem for Ohm's law? There are two 'Library' directories in my OS X 10.11 installation, one being /Library/, the other being /System/Library/. What is the difference between different Library folders? I asked this question  but I haven't gotten a useful answer. Could you tell me the difference in meaning between these sentences?        Do you think you will visit them next week?     Will you visit them next week?     Are you going to visit them next week?     Are you visiting them next week?     Are you going to be visiting them next week?     Are you planning to be visiting them next week?     Do you plan to visit them next week?      Will there be any difference in the answers?        I think I will visit them next week.     I will visit them next week.     I am going to visit them next week.     I am visiting them next week.     I am going to be visiting them next week.     I am planning to be visiting them next week.     I plan to visit them next week.      Can I use "planning to" instead of "going to"?  (E.g. "Are you planning to visit them next week? — Yes, I am planning to visit them next week.") Which of these sentences show that the subject of conversation has already been discussed? For example, I talked with a friend of mine about my plans to visit somebody. So my friend is aware of my plans.  And my last question. Which of these seven sentences express that the action will certainly take place? How do we see? Where do the photons disappear? The the title is self explanatory, I guess.  Why can two (or more) electric  never cross? I have a good intuition that $A$ is independent of $B$ if $P(A \vert B) = P(A)$, and I see how you can easily derive from this that it must hold that $P(A,B) = P(A)P(B)$.    But the first statement is not normally taken as a definition; instead the second is.    What is the intuition, or even derivation behind defining $A$ and $B$ as independent iff $P(A, B) = P(A)(B)$?    The kind of explanation I am looking for would be one similar to that given by Jaynes for the definition of conditional probability in the first chapter of Probability: The Logic of Science, or even a Kolmogorov axiomatic explanation would help. ibus Avro in Ubuntu 14.04 LTS I used the instructions given  to install ibus Avro in my ubuntu 14.04 LTS (64 bit) but ibus avro was not installed. Can anyone help me to solve this case? After giving the commands in terminal nothing happens. Actually I have installed the new Ubuntu 15.04 64bit, and when I'm trying to install Steam on it, there is a problem. In fact I have downloaded the deb package from steam website, installed it and when I start it nothing happens. I tried to start it from terminal and what I've got  $ steam Running Steam on ubuntu 15.04 64-bit STEAM_RUNTIME is enabled automatically Installing breakpad exception handler for appid(steam)/version(0_client) libGL error: unable to load driver: r600_dri.so libGL error: driver pointer missing libGL error: failed to load driver: r600 libGL error: unable to load driver: swrast_dri.so libGL error: failed to load driver: swrast