I have a table like this :   id  | movie   | actorid | actor   | roleid | rolename  ----+---------+---------+---------+--------+------------------  1   |  mi3    |  121    | tom     |   6    |  actor  2   | avenger |  104    | scarlett|   4    |  actress  2   | avenger |  3      | russo   |   2    |  action director   I'm expecting the output like :  id  | movie   | actorid |      actor     | roleid | rolename ----+---------+---------+----------------+--------+-------------------------- 1   |  mi3    |  121    | tom            |   6    |  actor 2   | avenger |  104,3  | scarlett,russo |   4,2  |  actress, action director   For latest SQL Server version, I saw the STRING_AGG function to concatenate columns or row data. But how can I achieve the expected output with SQL Server 2014 using STUFF ?
How do I get:  id       Name       Value 1          A          4 1          B          8 2          C          9   to  id          Column 1          A:4, B:8 2          C:9
Is it acceptable to use "is become" instead of "has become"? In the King James version of the Bible there is a verse like this:     The Lord is my strength, and my fortress, and my song. And He is become my salvation.   Is it still feasible to use "is become" instead of "has become" and what is the semantic difference? How to get a list of the filenames of the figures embedded in a document I have a TeX document that is embedding a huge amount of figures from a fig folder that is full of another humongous amount of other figures.  I would like to move the document along with its figures, but I don't want to take the whole fig folder, just the figures in there that are embedded by the document.  Is there a package (or any other way) that allows me to, for example, print out the filenames of all the figures embedded by the document? Something like:  fig/figurename1.eps fig/figurename2.eps ... etc   I could then just copy-paste that list and add some cp's in a plain text file and automate the copy of those files to my desired location by running the file in my shell:  $ cp fig/figurename1.eps wherever/fig/ $ cp fig/figurename2.eps wherever/fig/ ... etc   Of course this is just an idea, if somebody has an alternative to the "file listing and copy-pasting in a shell file" I would be happy to listen =) I'd like to copy files from one external drive to a network connected drive. I want to make sure that there are no errors.  I know of MD5 hash files that I see for large single files that are download from the internet. I also know that I can use the terminal to 'diff' the two sets of files.  However, I'm looking for a piece of software that could confirm that all the files in the file structure have been copied by the finder completely, or a piece of software that would do the copying for me and confirm that all the bits are exactly the same.  The files are video related - and are often over a TB in size (not in one file - complex multi-folder nested files)  I'm fine if there is a terminal command that can do the copy and compare for me as well. (although being able to see the amount of time left on a copy is a very nice feature... additionally, I want to make sure I get ALL of the file - resource forks and all) "POSSIBLE BREAK-IN ATTEMPT!" in /var/log/secure — what does this mean? I've got a CentOS 5.x box running on a VPS platform. My VPS host misinterpreted a support inquiry I had about connectivity and effectively flushed some iptables rules.  This resulted in ssh listening on the standard port and acknowledging port connectivity tests. Annoying.   The good news is that I require SSH Authorized keys.  As far as I can tell, I don't think there was any successful breach.  I'm still very concerned about what I'm seeing in /var/log/secure though:     Apr 10 06:39:27 echo sshd[22297]: reverse mapping checking getaddrinfo for 222-237-78-139.tongkni.co.kr failed - POSSIBLE BREAK-IN ATTEMPT! Apr 10 13:39:27 echo sshd[22298]: Received disconnect from 222.237.78.139: 11: Bye Bye Apr 10 06:39:31 echo sshd[22324]: Invalid user edu1 from 222.237.78.139 Apr 10 06:39:31 echo sshd[22324]: reverse mapping checking getaddrinfo for 222-237-78-139.tongkni.co.kr failed - POSSIBLE BREAK-IN ATTEMPT! Apr 10 13:39:31 echo sshd[22330]: input_userauth_request: invalid user edu1 Apr 10 13:39:31 echo sshd[22330]: Received disconnect from 222.237.78.139: 11: Bye Bye Apr 10 06:39:35 echo sshd[22336]: Invalid user test1 from 222.237.78.139 Apr 10 06:39:35 echo sshd[22336]: reverse mapping checking getaddrinfo for 222-237-78-139.tongkni.co.kr failed - POSSIBLE BREAK-IN ATTEMPT! Apr 10 13:39:35 echo sshd[22338]: input_userauth_request: invalid user test1 Apr 10 13:39:35 echo sshd[22338]: Received disconnect from 222.237.78.139: 11: Bye Bye Apr 10 06:39:39 echo sshd[22377]: Invalid user test from 222.237.78.139 Apr 10 06:39:39 echo sshd[22377]: reverse mapping checking getaddrinfo for 222-237-78-139.tongkni.co.kr failed - POSSIBLE BREAK-IN ATTEMPT! Apr 10 13:39:39 echo sshd[22378]: input_userauth_request: invalid user test Apr 10 13:39:39 echo sshd[22378]: Received disconnect from 222.237.78.139: 11: Bye Bye     What exactly does "POSSIBLE BREAK-IN ATTEMPT" mean?  That it was successful? Or that it didn't like the IP the request was coming from? How to remove or hide the GRUB boot menu? I need help with this:  If a is an element of $\mathbb Z_n$ and $\gcd(a,n) &gt; 1$ , then a is not invertible.   First you show that if $a$ is an element of $\mathbb Z_n$ and $\gcd(a,n)&gt;1$, then there  is an element $b$ of $\mathbb Z_n$ and ($b$ is not equal to the zero element) from which $ab = 0$.   The second part I cant get. i.e. show if $b$ is not the zero element  and $ab=0$ then $a$ is not invertible. Show that $1^{p-1} + 2^{p-1} +\ldots + (p-1)^{p-1} \equiv -1 \mod p$ Show that    $$1^{p-1} + 2^{p-1} +\ldots + (p-1)^{p-1} \equiv -1 \mod p$$   So, I use Fermat's little theorem, that is if $p$ does not divide $a$, then $a^{p-1}$ is congruent to $1$ (mod $p$). But I'm still confused. If $1^{p-1}$ is congruent to $1$ (mod $p$), $2^{p-1}$ is congruent to $1$ (mod $p$), and $p$ does not divide $p-1$, so $(p-1)^{p-1}$ is congruent to $1$ (mod $p$). How does that equal $-1$ (mod $p$)? Why multiplying fractions is equal to multiply the tops, multiply the bottoms? $$\frac{a}{b}\times \frac{c}{d}=\frac{a\times c}{b \times d},$$ And why $$\frac{a}{b}\times \frac{c}{c}=\frac{a}{b},$$ Also why $$\frac{a}{b}+\frac{c}{b}=\frac{a+c}{b}.$$ I understand it, but I want a mathematical approach as a math student proves it. Also I want to know the mathematics topic of this question (number theory, logic, etc). A full answer is not necessary. Just a reference. Issue with regex backreference in Python Connect Tikz nodes via two parallel arrows I am just starting to learn using Tikz and am a little lost within its seemingly infinite amount of options and possibilities.  What I am trying to do is visualize a few Matlab function interaction (which one calls which one, what is the in- and output). Since there are only about six subroutines, I place each one manually as a node. This is an example:  \documentclass{article} \usepackage{tikz} \usetikzlibrary{shapes,positioning}  \begin{document}  \begin{tikzpicture}[auto] \node           [rounded rectangle,draw]        (node1)     {Node 1}; \coordinate [above=of node1]                                (input); \node           [rounded rectangle,draw]    at  (-10:6cm) (node2)       {Node 2}; \draw           [-&gt;,very thick]             ([xshift=0.1cm]  input.south)  --                  node {right}                ([xshift=0.1cm]  node1.north); \draw           [-&gt;,very thick]             ([xshift=-0.1cm] node1.north) --                  node {left}                 ([xshift=-0.1cm] input.south); \draw                                            (node1) -- (node2);  \end{tikzpicture}  \end{document}     Now I would like to apply these double in/out arrows I (probably pretty awkwardly) created using xshift to all node connections, so in this example also for the connection between Node 1 and Node 2. Ideally, the space between these two arrows would be the same, independant of their angle and they would nicely connect to the outer line of the nodes. Any idea how I could achieve this? Similar questions I have found only used rectangle and orthogonal lines. Can you catch a native exception in C# code? In C# code can you catch a native exception thrown from deep in some unmanaged library? If so do you need to do anything differently to catch it or does a standard try...catch get it? While watching  I noticed a very characteristic camera shot. At a scene where the main character, Wendy, sits in her room at the computer (watching the supposedly foretelling fotos), her sister talks to her from the outside (asking if she can have the camera/fotos). There is a certain camera shot, where on the left side a frontal close-up of Wendy's face is shown, while on the right side you see her sister standing in full height inside the open door.    This shot immediately struck me as being somehow characteristic and out of place and infused feelings to me of some kind of older Hitchcock or Brian De Palma thriller or something the like. I also think to remember of having seen this kind of shot or something similar used in , where Jessica Lange is shown in front of the dresser talking to Nick Nolte who stands in the door or father away.  I would like to know if this technique has a certain name or theory behind it and where its origins lie, or if there is any particular director or movie who made this famous. It may be even that Final Destination 3 uses this especially in reference to some director or movie. In the book I'm study is written:     A normal subgroup of a group need not be characteristic.   And as an exercise I'm supposed to find an example, it also said that is pretty hard to find one. After trying for two days I wasn't able to find one example.   So, I'm asking for an example of a group $G$ with a normal subgroup $H$ that is not a characteristic of $G$.  I will add some context because maybe it will clarify why the book said it is difficult to find an example: the main problem with the exercise is that until it the book had only covered Group Definition, Subgroups, Lagrange's Theorem and Homomorphisms. So I'm supposed to find a example with such lack of advanced tools. Who is bound to the Prime Directive? What is $\Delta t$ in the time-energy uncertainty principle? Sorry, I'm still a newbie to blender, but why are some edges visible only in edit mode, but not in wireframe view? is it a bug or am I missing something here?  edit mode: Edges visible. Object mode, wireframe view: Pooff, they're gone. what can i do to fix this? / thanks I have a Windows 10 Home PC that is often unattended but doing important work. The work follows no particular schedule, and may take place at any time of day or night.  As things stand, Windows 10 (anniversary update) is configured to automatically restart and install updates during inactive times. The user can configure the inactive times, but the OS forces the user to have no more than 12 active hours a day. This means that the machine may well choose to restart at a time that is highly disruptive to our work and when there is no user around to prevent the restart.  For this reason, I would like to ensure that Windows never automatically restarts. How can I achieve this? Bolzano-Weierstrass Theorem Proof Abbott (Ax. of Choice) In Abbott's Proof of the Bolzano-Weierstrass Theorem, does Abbott use any form of the Axiom of Choice ?   I think he is since he chooses an $a_{n_k} \in I_k$ where there are multiple such $a_{n_k}$. Why is my attempt at downloading Big Sur failing? I am currently using a MacBook Pro 13&quot; Mid 2018 with Touch Bar. Today macOS Big Sur was released and I tried to download it but it's getting stuck at 484.4 MB. Initially, it shows 16-17 minutes left, but as soon as it reaches 484.4 MB it's stuck and the timer goes till 10 hours! My Wi-Fi is totally stable with a speed of 100 Mbps. I tried to restart my Mac but it still gets stuck. Earlier there were similar issues in the App Store (even now they are). The issue was I was not able to download an app unless I connect to the US VPN. I even contacted support but they were not able to help out. It wasn't a big deal as a VPN could be used. But now even with VPN, it gets stuck. How to pad zeroes to a string?