In SQL SERVER I need to output row data from a table while joining with another table and column data in second table should be comma separated for each first table row by a single query. If there is no matching rows in second table, It should Display NULL. Following are the tables.   Table 1     Table 2  ID  Name    Tlb1_ID CITY 1   A       1   ZZ 2   B       1   XX 3   C       2   GG 4   D       2   HH 5   E       3   JJ   I want the output is as follows Result        ID  Name CITY 1   A    ZZ,XX 2   B    GG,HH 3   C    JJ 4   D    NULL 5   E    NULL
Consider a database table holding names, with three rows:  Peter Paul Mary   Is there an easy way to turn this into a single string of Peter, Paul, Mary?
How to run Visual Studio post-build events for debug build only How can I limit my post-build events to running only for one type of build?  I'm using the events to copy DLL files to a local IIS virtual directory, but I don't want this happening on the build server in release mode. Let $F$ be a field and $f: \mathbb{Z} \to F$ be a ring epimorphism. Why there is a $\frac{1}{2}$ in the distance formula $d=\frac{1}{2}at^2$? I've been looking for the name of a sci-fi romance book about space travel but haven't been successful so far. I came across it a few years ago, read the plot on its back cover but didn't read the book. It is about two spacecraft pilots, a man and a woman, who travelled at light speed (or maybe FTL, I can't remember) in separate ships. Every time they return to Earth, centuries have passed on Earth because of time dilation. They meet each other for a few times on Earth in different eras, but don't know when, if ever, they will meet again. I don't know how it ends.   If anyone knows which book I'm talking about, could you please tell me the name? Thanks a lot! How to prevent RGB composite flatten to 1 band after raster calculation I have a series of landsat wanting to process in raster calculator, but after doing the tool it happened these output images only contain one single band. They used to be RGB 3-band images.  It is on arcmap 10.3. I was using raster calculator to remove a certain value in my 3-band landsat image. After I type in the conditional statement to remove all 0 value from the inpur RGB image, it only returns an image of 1band, black and white. How can I preserve the RGB value in output. How to create two partitions? How to vote on friends / colleagues ' questions (or answers) Almost every time a colleague of mine asks a question, we have discussed this problem beforehand. Also, we sometimes meta-discuss the question for stackoverflow (why did I get the &quot;this might be subjective&quot; warning, is this understandable enough, etc). This is less so with answers, but I could believe for some groups this works the same. For now I'll stick to questions, but you could s/question/answer if you like. The resulting question is almost always  Interesting for me, and a problem I don't know the answer to. I probably would favorite it According to me a valid and good question (as we talked about it beforehand) I would probably want to upvote it.  Now I believe to read that &quot;ring voting&quot; is a thing, and I tried to find some questions about this, but didn't find many. I did find and read this blogpost from 2008:  . It reads to me that upvoting 'fraud' is more commonplace then downvoting and it might seem anomalous that I would upvote almost all questions from one user. If all colleagues would do this to their team, you'd get some mediocre questions getting a lot of votes, and some users getting a lot of attention, points etc from that. If you would -as seems to be done -, sort the amount of upvotes for my colleague, you'd get me being 'anomalous' in front of the crowd. On the other hand, as explained above, I do want to upvote almost all stuff some of my colleagues put on here for (I believe) the right reasons: they are questions I consider good and interesting. It's just that I know of all their questions (as they tell me about them), which obviously isn't the case for a random user. So what is the deal?  When is upvoting content from one user frowned upon? Would my usecase be in danger of being a (what I consider 'false') positive for the fraud-detection? (and would you agree with that or not) How to prevent this false positive (if you agree with me it is one, otherwise this is a moot question) -&gt; As noted in the comments: I'm not looking for tricks, so an answer could be &quot;don't vote for your colleagues&quot;. I agree that there should be no to 'tricks' around that could be used for real fraud of course Multiple forms in delphi How to escape quotes in shell? What makes the inside of a shape the inside? Preface: Every couple of days there comes a question of this type, which is easy to solve with sed, but takes time to explain. I'm writing this question and answer, so I can later refer to this generic solution and only explain the adaption for the specific case. Feel free to contribute.  I have files with variable definitions. Variables consist of uppercase letters or underscore _ and their values follow after the :=. The values can contain other variables. This is Gnom.def:  NAME:=Gnom FULL_NAME:=$FIRST_NAME $NAME FIRST_NAME:=Sman STREET:=Mainstreet 42 TOWN:=Nowhere BIRTHDAY:=May 1st, 1999   Then there is another file form.txt with a template form:  $NAME Full name: $FULL_NAME Address: $STREET in $TOWN Birthday: $BIRTHDAY Don't be confused by $NAMES   Now I want a script which replaces the variables (marked with $ and the identifier) in the form by the definitions in the other file, recursively, if necessary, so I get this text back:  Gnom Full name: Sman Gnom Address: Mainstreet 42 in Nowhere Birthday: May 1st, 1999 Don't be confused by $NAMES   The last line is to ensure that no substrings of variables get replaced accidentally. Today in the feed on the Android Stack Exchange app there is a Stack Overflow blog post. This post had the site icon next to it for  rather than the proper site logo (Meta).        Stack Exchange Android App Version 1.0.73 and 1.0.74 Android 5.1 on a Moto X (2013) running stock firmware.  Same behavior on a Nexus 7 (flo) running Android 6.0 (stock).  This issue also happens on the iOS app.    The most recent featured SO blog post (as of 17 Nov) is showing up with the "edX" site logo.  The logo is seemingly randomly incorrect. If you have a glass of water, say, three quarters full and you pour it at an angle of say, $45^{\circ}$ with respect to the the table, the water comes out of the glass and goes directly down towards the floor.  However, when the glass is more full, or even three quarters full and the 'angle of pouring' is far less with respect the table, when the water comes out of the glass, rather than going straight down it kind of stays stuck to the glass and travels down the outside of it.  Why does this happen? (I'm sure many of you have observed it yourself by accident and ended up making a mess). Generating random integer from a range What is a "closed" or "duplicate" question? Questions can be closed or marked as duplicates.  What does it mean for a question to be &quot;closed&quot;? What does it mean for a question to be marked as a &quot;duplicate&quot;? Who can close a question? What are the reasons for closing a question ? Is closure the end of the road for a question? When are closed questions eligible for deletion?   Related        For more information, see &quot;&quot; in the . Find the equation of the plane passing through a point and a vector orthogonal I have come across this question that I need a tip for.     Find the equation (general form) of the plane passing through the point $P(3,1,6)$ that is orthogonal to the vector $v=(1,7,-2)$.   I would be able to do this if it said "parallel to the vector"  I would set the equation up as $(x,y,x) = (3,1,6) + t(1,7,-2)$ and go from there.  I don't get where I can get an orthogonal vector. Normally when I am finding an orthogonal vector I have two other vectors and do the cross product to find it.  I am thinking somehow I have to get three points on the plane, but I'm not sure how to go about doing that.  Any pointers?  thanks in advance. What is the rationale for all comparisons returning false for IEEE754 NaN values? QGIS creating a fixed distance buffer over selected areas not the entire layer what im doing is making a fixed distance buffer and it's working splendidly but i need the buffer to be created over certain selected areas not the entire layer, and at the creation wizard is only offers the the option of selecting the entire layer, and i need some areas within that layer to have a different buffer and some none at all.  is there a way around that? Using NPN transistor as switch Cards entering the battlefield simultaneously and "Enter the Battlefield" effects I was playing modern with the owner of a shop.  He played a  which he used to bring in 7 lands: 5 basic mountains and 2  cards.  He then claimed that each  triggered 5 times (killing me).  I am doubting this now.    Here is my reason: The two  cards entered at the same time as the other 5 basic lands.  That means when they were on the battlefield and their ability was in effect, the other 5 basic lands were already there too.  That seems too late to trigger a "Enters the Battlefield" effect.  So here is my question.  Am I right or wrong?  If I am wrong, please show me how the enter the battlefield effect can trigger for something that enters the battlefield at the same time as itself.  If I am right, please show me the rules that prove it.  I now have two shop owners that are convinced that this is a legal play.  If it is not legal, I am going to need clear rules citations to convince them.    Side note:  If I am wrong and it is a legal play, then I have a follow up scenario.  Say I have 2  cards and 5 other human cards in my graveyard.  If I play a spell that lets me return all of them to the battlefield at the same time (say ), would the  cards get 6 +1/+1 counters on them?    To me, if the trick that was played on me with  is legal then my  cards should also get the +1/+1 counters.