How to group the result of a SQL Server query (group by not working)
Simulating group_concat MySQL function in Microsoft SQL Server 2005?
Calculate line distances inside of polygons using ArcGIS for Desktop? I'm working with two data sets:   NHD polyline stream layer for my entire state HUC Watershed boundary Polygons for the entire state   I am looking for a way to calculate the total length of streams within each watershed boundary polygon, and would ideally like to have each polygon then attributed with the sum of stream miles within its boundary.  Can anyone help me? External hard drive very slow to load after dropping it and can't be repaired with Disk Utility Today as I was using my WD HDD, it fell off my corner. After I fixed the thing, I plugged it into the Mac and it loads the HDD but it's very very very very slow. It also does not work sometimes. The entire laptop just hangs  Tried running Disk Utility First Aid but it won't work.  It says some error and hangs  Can someone advise me on what I can do in this case? How do you create a bootable USB stick using windows 7 I've downloaded Ubuntu desktop (the .iso file that is) on a windows 7 machine and want to create a bootable USB stick in order to install it onto a laptop which currently has no OS. Is there a way to do this? Numlock turned on on boot-up I have a desktop running ubuntu 10.04  I want numlock to be turned on initially.  What do I have to change to accomplish this?  ~~edit~~  I checked in my BIOS.  It was already set up to have the numlock turned on initially.  Yet it isn't being turned on initially.  I have a USB keyboard: would that break this functionality?   Or, should I ask elsewhere (superuser, perhaps) about how to get that BOIS setting working properly? Modified pattern does not see the pattern color option Can one construct a non-measurable set without Axiom of choice? Is axiom of choice required to show the existence of non-measurable sets? Is there a Lebesgue non-measurable set that can be constructed without axiom of choice?  Related question on MO says it is consistent: I think it would be good to have a way for the user to view the target URL of a link before following it. I'm pretty sure that I'm not the only one who dislikes blind-clicking -tapping links.   When I use SE in the mobile browser, I routinely long-press links to find out where they go before following them. I wish I could do the same thing in the app, with the same or a similar method.  (It's important that this won't conflict with text selection, since you can't long-press on links to select them now anyway.) Considering phrases of the form "I left [the] X", what causes some words to need a "the" before them, while it sounds awkward with others?  Needs "the":   I left the office I left the bank I left the house I left the courthouse   Awkward with "the":   I left work I left social media I left New York   Either way works:   I left [the] school I left [the] church Let $|A|=\alpha, |B|=\beta, |C|= \gamma$ be cardinals and $\beta \leq \gamma$. Prove $\alpha ^{\beta}\le \alpha ^{\gamma}$.  So from the given we know that there's an injection $f:B\to C$ and some functions $h:B\to A, g: C\to A$. We want to prove there's an injection $l_1:A\to C$. It appears that $f$ doesn't help here.  Trying to take representatives from $A$ and show they're in $C$ and there's an injection doesn't work so maybe the function should be $l_2: h \to g$ but I don't know how to work with it. I have a code that loops through all the Sites and Webs in a web application.  My code uses for..each loop to navigate through each site and web object.  I was wondering if we are required to dispose the SPWeb and SPSite objects when used inside a loop.  Codes:-  foreach (SPSite thisSite in siteAuditWebApplication.Sites) {  //My operation here  }  Similar to the above code I also have some part of code that loops through all the Web and Lists.  Do we have any best practice for disposing objects inside the loop,  or do i really need to take care about disposing the objects?  Thanks in Adv.. Sudhir Access images inside jar Structure of ideals in the product of two rings $R$ and $S$ are two rings. Let $J$ be an ideal in $R\times S$. Then there are $I_{1}$, ideal of $R$, and $I_{2}$, ideal of $S$ such that $J=I_{1}\times I_{2}$.  For me it's obvious why $\left\{ r\in R\mid \left(r,s\right)\in J\text{ for some } s\in S\right\}$ is an ideal of $R$ (and the same for $S$) so I can prove $J$ is a subset of the product of two ideals and also that the product of these two ideals is an ideal. But I can't see how to prove equality without assuming existence of unity or commutativity. Trying basically to show that if $\left(r,s\right)\in J$ then also $\left(r,0\right),\left(0,s\right)\in J$. Thank you for your help! I am intermediate in PHP. To polish my skills I start learning Drupal 7. While learning Drupal architecture concepts, the terms hooks and bootstrapping puzzled me a lot. I read the "Pro Drupal development" book, and some documentation on drupal.org, but it is so advanced for me to learn how hooks work in Drupal to display the web page.  Can anyone tell me what hooks are in simple words? When I try to set the default combo for switching to different language layouts in my keyboard from Shift+Super+Space to Alt+Shift I can't.  I used to have this combo since Ubuntu 14 and even before that when I used to have Windows. Now for some stupid reason it does not allow (actually nothing happens its not like I get an error or the combo is used elsewhere). How could I bypass this bug? Suppose $G=\{a_1,...,a_n\}$ is a finite abelian group, and let $x=a_1a_2\dotsm a_n$.   Prove that if there is more than one element of order $2$ then $x=e$.   What I've done so far: (#1 is just for illustration, There should be at least $3$ such elements)   $G$ has an even number of elements with order $&gt;2$ (They are paired so: $(a,a^{-1})$ ). And then there are $e$ and $\{b|o(b)=2\}$. Also, if $G$ has at least one element of order 2 then $|G|$ is even (Lagrange). Thus $|\{b|o(b)=2\}|$ must be odd. If there is exactly one element $b$ of order $2$ then $x=b$. That's because $G$ is abelian, and we can write: $x=e\cdot b\cdot(a_1 a_{1}^{-1}\dotsm a_n a_{n}^{-1})=b\cdot(e\dotsm e)=b$. If there are exactly $3$ such elements $a,b,c\in G$, then, as shown above, $x=abc$ and thus $x=e$ (That's because $(abc)^2=a^2b^2c^2=e$ which means $abc\in \{a,b,c,e\}$. If $abc=a$ then $b=c^{-1}=c$ which is false, same goes for $abc=b,abc=c$.)   I haven't managed to find a reason why the claim must hold for $5, 7, ...$ (i.e. All other odd integers). Does anyone have an idea?  Thanks in advance. Please excuse my English.  edit: Not a canonical answer but a simple one (if such even exists). Saving an Adobe illustrator file as a pdf - are fonts embedded? If so, why does Adobe illustrator say I don't have the font when I open it? If I have an Adobe Illustrator file, and I save it as a .pdf - it looks like the fonts are included in that .pdf file. (I think this because when I open the .pdf file in Reader it looks the way I expect it to.) However, when I open this same .pdf file on a different computer (or workstation) with Adobe Illustrator - Illustrator says I 'don't have the font I need'. This doesn't make sense to me because - If I can see the document correctly in reader, I would expect it to be there for Illustrator as well. Can someone explain why this is? I am asking because saving a file as a .pdf for print seems to handle most font troubles that come up - but sometimes I need to change the text in a file before I print it... I am hoping there is a way to open a .pdf so that .ai recognizes that the font is in there.  But I am unsure on the details of saving as a .pdf in Illustrator, how fonts are handled, and what is possible. Are virtual particles only a fictive tool in equations? There is no "action at a distance" in nature. Attraction of a piece of iron by a magnet, attraction between distant electric charges of opposite sign, have to be mediated by something. The  are proposed as an explanation.  If they have an observable effect, it seems like they must exist. If so, why do we call them virtual? It can't be that they have short lifetimes, as there are short-lived particles (resonances) that we don't call "virtual."  On the other hand, some people say that the so-called virtual particles only exist on paper, or that they are just a technique to help us handle our equations.  So what is the meaning of the word "virtual" here? Do these particles really exist, or not? What's the difference between a Long Term Support Release and a Normal Release? What are the differences between an Ubuntu Long Term Support release (LTS) and a normal release? I want to know where the Metro applications (Mail, People, Messages, ...) executable file path is.  Also, how can I run Mail application when my PC starts? Is this intended behavior (with plain XeTeX):  \input tikz \tikz\draw[dashed] node {$3T\over4$}; \bye   It renders as: !?  The fraction line is dashed, too! Is this intentional? Is there something I can do to change that? I know I can separate the fraction into its own node, but other than that?