How to merge multiple rows into single row if the id is same?
How to concatenate text from multiple rows into a single text string in SQL server?
We are going to change the IP address of our SharePoint Servers can any one point out the RISK and IMPACT Calculating difference in dates in Java I find it funny that Java (or the java.util library) does not have a built-in function to calculate difference in dates. I want to subtract one date from another to get the elapsed time between them. What is the best way to do this?   I know the simple way is to take the difference of the time in milliseconds and then convert that into days. However, I wanted to know if this works in all cases (with daylight saving, etc.). I'm learning how to use the mirror modifier and I am having some trouble.  When I apply the modifier to my object I don't see a mirrored version of it.  What am I doing wrong? `tail -f` until text is seen I've got a CI server with a command-line interface that allows me to remotely kick-off a job (jenkins CI server and the jenkins-cli.jar tool).  After I kick the job off I tail -f the log (sorry for the messy command):  ssh -t my-jenkins-host.com "tail -f \"/var/lib/jenkins/jobs/$job_name/builds/\`ls -ltr /var/lib/jenkins/jobs/$job_name/builds/ | grep '^l' | tail -n 1|awk '{print \$9}'\`/log\""   After the job successfully completes, usually after at least 5 minutes, I get the following line on the output:  Finished: SUCCESS   Is there a good way to stop tailing the log at this point? i.e. is there like a tail_until 'some line' my-file.log command?  BONUS: extra credit if you can supply an answer that returns 0 when SUCCESS is matched, 1 when FAILURE is matched, and your solution works on mac! (which i believe is bsd based) I want to advance in the ranks of Senator Lavigny-Duval. How can I get merit points? I know I can participate in expansion goals, but is there a better way than that? What is the difference between "why are you worried" and "why you are worried"? What is the difference between these two sentences?     Why are you worried?   Why you are worried?   Which one is correct? How do the likely/unlikely macros in the Linux kernel work and what is their benefit? I am trying to prove the existence of the square root of $2$.  I have some steps with a very vague explanation and I would like to clarify.  The proof: Let  $$S=\{x\in\mathbb R\mid x\geqslant 0 \text{ and } x^2&lt;2\}.$$  I understand the proof of LUB, ∝   and so I am at the step where $\alpha^2=2$.  I know that we are to prove by contradiction so we state let $\alpha^2 &lt;2$ and $\alpha^2 &gt;2$.  Now my instructor wants us to use the Archimedean Axiom $1/n = \varepsilon$.    $(\alpha^2 + 1/n)^2$  then what..... How to view an encrypted view or stored procedure I am working on a third party database.  When I try to view the definition of a view by right clicking, CREATE TO and then to NEW QUERY EDIT WINDOW, I am getting an error:     This property may not exist for this object or may not be retrievable   due to insufficient access rights. The text is encrypted. How (and why) use stderr for both reading and writing? According to , less reads navigation commands from stderr if it's not able to open /dev/tty.  This seems puzzling, since I've never seen anything write to another program's stderr stream, and I don't know how I would even accomplish that.  What is the purpose of stderr being open for both reading and writing? And if this is useful, how do I make use of it on modern systems? (Is there some arcane syntax to pipe something into stderr instead of stdin, for instance?) Show that antipodal points remain antipodal under any isometry of $S^2$ "The antipodal map of $S^2$ is the isometry $\bar m$ sending each point $P$ to its opposite point $-P$" (from textbook)  Show that antipodal points remain antipodal under any isometry of $S^2$. In other words, for each isometry f of $S^2$, if $P$ and $P'$ are antipodal, then so are $f(P)$ and $f(P')$  I am unsure how I can define the $P$ and $P'$ so that they are opposites of each other in the antipodal map, and am I supposed to apply the traditional isometries (translation, reflection and rotation) to the points? I don't understand this problem. iCloud says Password is Wrong Even Though I Know It's Right iCloud says that my password is wrong - even though I know it's right.  Here's whats happened: Yesterday, I reset my iCloud password. Got the reset email, changed password. Tried to log in to the account, didn't accept it. I thought that maybe my finger had slipped typing in the password (twice). I called support, got the reset email.  Now, here's the really, really weird thing: I wanted to make sure I got the password right - so I typed my password into TextEdit, copied it into the reset fields and reset the password. After reseting it, I immediately went to icloud.com and tried to log in using the copied password from TextEdit. The passwords are the same. iCloud won't let me in. Neutrino Oscillations and Conservation of Momentum I would like to better understand how neutrino oscillations are consistent with conservation of momentum because I'm encountering some conceptual difficulties when thinking about it. I do have a background in standard QM but only rudimentary knowledge of particle physics.   If the velocity expectation value of a neutrino in transit is constant, then it would appear to me that conservation of momentum could be violated when the flavor eigenstate at the location of the neutrino source is different from that at the location of the interaction, since they are associated with different masses.  For this reason I would think that the velocity expectation value changes in transit (for instance, in such a way to keep the momentum expectation value constant as the neutrino oscillates), but then it seems to me that the neutrino is in effect "accelerating" without a "force" acting on it (of course, since the momentum expectation value is presumed constant, there may not be a real problem here, but it still seems strange).   Any comments? I keep reading articles about CCD vs CMOS image sensors. What is the difference between these two types? What exactly do these sensors do in terms of photography?  Is a CCD-based camera going to be able to compete in the future? If I buy one, can I count on using it for some years or would it be better to upgrade to a camera with a CMOS based sensor? Is there any advantage in marketing my product for £99.99 instead of £100? Let $f(z)=\sum_{n=0}^{\infty}a_nz^n$ be a holomophic function in the unit disc. Show that if $$\sum_{n=2}^{\infty} n\vert a_n \vert &lt;\vert a_1\vert$$ and $a_1\not = 0$, then $f$ is injective.   I am able to show that $f'$ never vanishes by showing that $\vert f'-a_1\vert &lt;\vert a_1\vert$, but that doesn't imply that $f$ is injective. For example, $e^z$ is not inejective but its derivative never vanishes. What is required to prove that $f$ is injective? How do you show $f$ is injective on any set? How to remove items from the right click (context) menu in Windows? The  is minimal and clean on a fresh installation of Windows. Install a bunch of applications and soon the context menu is loaded with all kinds of opening options from various applications.  How do I remove items from the right click (context) menu?  I find that there are different types of right click menu items:   Global items that appear in all context menus. Items that appear only on folders. Items that appear only on files. Items that appear only on special folders (Ex: Right clicking a folder of MP3s shows up a context menu with items like Play with Windows Media Player.) Items that appear only on certain file types (Ex: Right clicking a MP3 file shows up a context menu with items from Windows Media Player/Foobar2000/VLC/your-favorite-media-player begging to open this file.)   I want to be able to delete all these kinds items from the right click (context) menu. Help me to get command or ansibile Regex to fetch below details Possible Duplicate:          I have seen  in SQL. I wonder how would you approach the opposite problem: splitting coma delimited string into rows of data:  Lets say I have tables:  userTypedTags(userID,commaSeparatedTags) 'one entry per user tags(tagID,name)   And want to insert data into table  userTag(userID,tagID) 'multiple entries per user   Inspired by  question  EDIT  Thanks for the answers, actually more then one deserves to be accepted but I can only pick one, and the  with recursions seems pretty clean to me. It works on SQL Server 2005 and above.   For earlier version of SQL Server the solution  can be used.  For working with text data type  will be helpful. Thanks again. Cannot find my keyboard layout I'm in Belgium (french part) and I cannot find the proper keyboard layout in Settings > Region and Languages > Input Sources.  the closest I found is the french (AZERTY) one but for the symbols such as ! and _ it's not the same keys...  what can I do to solve it ?  Thank you.