MSSQL 2008 for xml path concatenation query
Simulating group_concat MySQL function in Microsoft SQL Server 2005?
Teenage girl in life-sustaining valley on poisoned Earth visited by another survivor I am an Indian citizen studying in Italy on an Italian visa that expires 19 November, 2015. I have permesso di soggiorno. I want to visit the United Kingdom for my vacations for a week during March. I know the procedures already, however I am a little bit confused about the amount that I must show as a proof of support with my bank statements. I will stay for a week with my friends who are also students in Italy and will be in London for 5 days. What would be the amount in Euros that I need to show for my visit to UK? I'm listing some items for sale online, and have taken a bunch of pictures with my iPhone.  About half-way through the process, iPhoto '11 stopped downloading new photos into its local Photo Stream.  I've quit iPhoto and re-opened it.  I've gone into the Photos app on my iPhone and confirmed all the pictures are there.   Is this normal behavior? Is there any way to tell iPhoto to download my pictures? Is system cleanup/optimization needed Does Ubuntu need regular cleanups like Windows. For example:   Cleaning the logs Temporary files Package cache Dependencies left over   I am not referring to web browsers only.  In case I never do a cleanup, will I have a system like new without my hard drive being full of temporary files, packages, etc.?  Will the performance degrade overtime if a cleanup is not done. Taking ownership of comments on migrated questions When a question is migrated to a SE site that I'm not registered to, I can't claim ownership of my comments. An example question:   I registered only after the question was migrated and can't delete my comments. I always like to perform some garbage collection of noise comments made by me. (like on the example question)  Would it be possible to claim ownership of comments in this scenario? Is this a bug? I'm reading that a 50mm lens is recommended as a first prime lens for DSLR owners as it's supposed to give a 'natural' perspective, but when used on (most) DSLRs, the view is cropped, as if you were zoomed in by 1.5-1.6x, so it's more of a telephoto lens when used on a DSLR. I've also read however that the 50mm lens gives the same perspective on a DSLR and a 35mm, and shouldn't really be considered to be 'equivalent' to an 80mm lens as the crop factor isn't really a magic focal length changer.  Can someone explain how the image is different from (for example) a 50mm lens on a DSLR and an 80mm lens (assuming 1.6x crop factor) on a 35mm camera? For one of the clients, I have spin up a modern communication site collection and on the landing page of the same, I am seeing 'Get the mobile app' showing up, I was able to hide the 'feedback' button using css but no luck with Get the mobile app button.  Can someone please share css to hide 'get mobile app' button, appreciate the help. How to pivot rows into columns MySQL Been looking to pivot rows (progress_check) into columns check 1, check 2 etc... No sum or totals required, just to display the results hopefully... Can anyone help, Thanks Ad Use Complete Induction of set theory to prove $\frac{1}{\sqrt{1}} + \frac{1}{\sqrt{2}} + \frac{1}{\sqrt{3}} + ... + \frac{1}{\sqrt{n}} > \sqrt{n}$. Proove by the Complete Induction for every $n\in \mathbb{N}, n \geq 1$ $$\frac{1}{\sqrt{1}} + \frac{1}{\sqrt{2}} + \frac{1}{\sqrt{3}} + ... + \frac{1}{\sqrt{n}} &gt; \sqrt{n}$$.  I know only the basis - $\frac{1}{\sqrt{1}} \geq \sqrt{1}$.  But, I dont know how to do the change from the regular induction to the induction of Set theroy(Complete Induction). Tricks and tips for finding information in man pages Does anyone have any tricks and tips for finding information in man pages? Network simplex method, leaving and entering variables So I've started playing Gathering Storm, built a bunch of coal plants and now Global Warming is out of control mainly because of me. I've been trying to remove these power plants, but I haven't found any option to sell/destroy or even replace these buildings.  Is there seriously no way to do this? Can I use my familiar to cast Warding Bond on myself? Find Familiar lets you cast touch spells through your familiar. Warding Bond is a Touch spell, that creates a connection between "you and the target". I can't find anything against it, but would it be possible to have my Wizard make his familiar cast Warding Bond on the Wizard himself, so that the Wizard gets the +1 to AC and saving throws and resistance to damage?  I realized after I wrote this much that Wizards don't get Warding Bond, but I think the question is still valid for multiclassers. I have the following $n\times n$ matrix:  $$A=\begin{bmatrix} a &amp; b &amp; \ldots &amp; b\\ b &amp; a &amp; \ldots &amp; b\\ \vdots &amp; \vdots &amp; \ddots &amp; \vdots\\ b &amp; b &amp; \ldots &amp; a\end{bmatrix}$$  where $0 &lt; b &lt; a$.  I am interested in the expression for the determinant $\det[A]$ in terms of $a$, $b$ and $n$.  This seems like a trivial problem, as the matrix $A$ has such a nice structure, but my linear algebra skills are pretty rusty and I can't figure it out.  Any help would be appreciated. How to determine if string contains specific substring within the first X characters Testing random variate generation algorithms Which methods are used for testing random variate generation algorithms? How to obtain optimal hyperparameters after nested cross validation? Prove if $|a_{n+1}|/|a_n| \leq |b_{n+1}|/|{b_n}|$ and $\sum |b_n|$ is convergent, then $\sum |a_n|$ is convergent A required field that isn't really required? ...the email field in my clients data entry system is required but users of the system are allowed to enter na@na.com if the customer refuses or doesn't have an email address. Is this best practice? Have any suggestions or workarounds for their solution? Probability of 3 people in a room of 30 having the same birthday I have been looking at the birthday problem (http://en.wikipedia.org/wiki/Birthday_problem) and I am trying to figure out what the probability of 3 people sharing a birthday in a room of 30 people is. (Instead of 2).  I thought I understood the problem but I guess not since I have no idea how to do it with 3.