SQL Server how to select collapse row?
Merge duplicate records into 1 field
Ignoring accented letters in string comparison I need to compare 2 strings in C# and treat accented letters the same as non-accented letters. For example:  string s1 = "hello"; string s2 = "héllo";  s1.Equals(s2, StringComparison.InvariantCultureIgnoreCase); s1.Equals(s2, StringComparison.OrdinalIgnoreCase);   These 2 strings need to be the same (as far as my application is concerned), but both of these statements evaluate to false. Is there a way in C# to do this? Why was Dumbledore worried by the cut in Harry's arm? In the Goblet of Fire, Harry is cut in the arm by Pettigrew. When Dumbledore learns it, he's extremely worried and wants to check Harry's arm.  Why?     When Harry told of Wormtail piercing his arm with the dagger, however, Sirius let out a vehement exclamation and Dumbledore stood up so quickly that Harry   started. Dumbledore walked around the desk and told Harry to stretch out his arm.   Harry showed them both the place where his robes were torn and the cut beneath   them.      "He said my blood would make him stronger than if he'd used someone else's,"   Harry told Dumbledore. "He said the protection my - my mother left in me - he'd   have it too. And he was right - he could touch me without hurting himself, he   touched my face."      For a fleeting instant, Harry thought he saw a gleam of something like triumph in   Dumbledore's eyes. But next second. Harry was sure he had imagined it, for when   Dumbledore had returned to his seat behind the desk, he looked as old and weary   as Harry had ever seen him.      "Very well," he said, sitting down again. "Voldemort has overcome that particular   barrier. Harry, continue, please.     Edit:  Plz explain this sentence specifically:     "Dumbledore walked around the desk and told Harry to stretch out his   arm." Which Java Collection should I use? Create an entry in index without creating a Chapter or Section title MSBuild exec task with for I am trying to run the following commands as part of an MSBuild script:  for /R . %f in (*.targets) do copy /Y "%f" "C:\Program Files (x86)\MSBuild\Microso ft\VisualStudio\TeamBuild"   The commands is implemented in an exec the following way:  &lt;Exec WorkingDirectory="$(SolutionRoot)" Command="for /R . %f in (*.targets) do copy /Y &amp;quot;%f&amp;quot; &amp;quot;$(MSBuildExtensionsPath)\Microsoft\VisualStudio\TeamBuild&amp;quot;" /&gt;   The command works fine from console, but when trying to run it from MSBuild I get the error:   Task "Exec"   Command:   for /R . %f in (*.targets) do copy /Y "%f" "C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\TeamBuild"   f" "C:\Program was unexpected at this time. C:\Users\rd-build\AppData\Local\Temp\OH Test2\Continuous.BuildTargets\BuildType\TFSBuild.proj(98,5): error MSB3073: The command "for /R . %f in (*.targets) do copy /Y "%f" "C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\TeamBuild"" exited with code 255. Done executing task "Exec" -- FAILED.   Any suggestions? Badge icons missing in Achievements of mobile view The badge icon followed by the site icon in the Achievements dialog is missing in the mobile view. But the same is available in the full site view.  Screenshots for reference:  Achievements - Full site view:        Achievements - Mobile view: If $xy + yz + zx = 1$, then show that      $$\dfrac{x}{1-x^2} + \dfrac{y}{1-y^2} + \dfrac{z}{1-z^2} = \dfrac{4xyz}{(1-x^2)(1-y^2)(1-z^2)}$$   I tried doing the sum algebraically, that is, by solving the LHS but, that method isn't really getting us anywhere.  Also, I found this sum in an a book on trigonometry. So how can I solve it with trigonometry? ls command operating differently depending on recipient How does commands like ls know what its stdout is?  It seems ls is operating different depending on what the target stdout is. For example if I do:  ls /home/matt/tmp    the result is:  a.txt b.txt c.txt   However if I do  ls /home/matt/tmp | cat   the result is (i.e. new line per result):  a.txt b.txt c.txt   The process is passed a file descriptor 1 for stdout right? How does it determine how to format the result? Does the file descriptor reveal information? Exact value for $\cos 36°$ Good morning! I'm having trouble with this problem... It's just taking me forever and I'm worn out and I'm lost on how to use a double angle identity for $72=2⋅36$  The problem reads as follows  An exact value for $\cos36°$ can be found using the following procedure. Begin by considering $\sin108°$. Note that $108=72+36$ and use the sine sum identity. Also note that $72=2⋅36$ and use double angle identities. If there are any common factors in each term, factor them out and cancel them if they are not equal to zero. You should eventually obtain a quadratic equation containing $\cos36°$. Use the quadratic formula to obtain the exact value for $\cos36°$. (Note that the quadratic formula should give two solutions. One can be disregarded - why?  Thank you in advance to anyone who can help. I have a simple skull model, to which I applied the subdivision modifier. For the most part everything works as expected, except I keep getting these weird sharp vertices and I can't seem to figure out how to flatten them.    I'm using Blender 2.8. Is this some kind of feature I can disable/enable for particular vertices? The distance between the sharp vertices and the gray outline differ.    Any suggestions please? Thank you!  EDIT: I also tried selecting as both - vertexes and edges and then applied Edge->Clear Sharp, but nothing changed. How can I set default terminal used in Unity? How can I set the default terminal used in Unity?  I would like to use the Ctrl+Alt+T hotkey to start a non-default terminal. The default terminal is gnome-terminal.   Where can I change the default terminal value? How can I Remove .DS_Store files from a Git repository? What medium should be used for long term, high volume, data storage (archival)? Initially, my question was: is "focussed" or "focused" the correct past tense of "focus", but since this applies to a lot of words, I would like to generalize and ask: is there supposed to be a rule when to double the consonant? I'm trying to identify fantasy book series I encountered some time ago. Here are things I remember:   it was a fantasy setting but with some s-f elements; with many worlds and possibility to travel between them; resembling  setting a little, the two main races were non-human and probably hostile to each other,  a labyrinth (?), which somehow played an important role in the plot, a protagonist was some kind of emissary and was sent on a mission to another worlds  time period: 80s - 90s    Does anyone know what it is the name of the series? I know that \: in LaTeX produces a space when rendered.  Are there any alternatives, because my LaTeX renderer doesn't support \: (it renders it as text), and there is no help / FAQ that I can find. install other packages when creating new package in R Prove that $(p+q)^m \leq p^m+q^m$ Align images with text without using tables Making data points different sizes based on data using QGIS? I am trying to plot sales data on a map using QGIS. I will add the disclaimer that I am a rookie at using the program. I added the different sales types by adding delimited text layers (utf16). The data included Longitude, Latitude, and Amount. I want to make the dots on the map scale with the value of the sale. Ive had no luck with trying to use Simple Marker->Data defined properties-> size and writing case functions. Some data points show up at different sizes while others show up at all data points. Here are my functions under different simple markers:   CASE WHEN Amount &lt;= 10000 THEN '.2' END CASE WHEN 10000 &lt; Amount &lt; 75000 THEN '.4' END CASE WHEN 75000 &lt; Amount &lt;= 250000 THEN '.6' END CASE WHEN Amount &gt;= 250000 THEN '1' END   The majority of my data set falls into the 10-75k range. However the .4 and .6 size circles show up at every data point on the map, while the .2 and 1 sizes only show up where the data specifies (along with the .4 and .6 sizes). At this point I am trying to figure out what is wrong with the equations, however I am stuck.   Is there a better way to go about this or am I just simply messing up the equations?   I wish I could share my whole map with you but it is looking great. I went with U/Joseph 's solution and here is an excerpt of the results for those interested.