Please help with SQL Query to solve following issue.  I have a table input values like this - Column header is X and Y      x | y -------------------     1 | a1     1 | a2     2 | a3     2 | a4     2 | a2   I need output like this  x | y ---------- 1 |a1,a2 2 |a3,a4,a2   Please advice!
I'm trying to migrate a MySQL-based app over to Microsoft SQL Server 2005 (not by choice, but that's life).  In the original app, we used almost entirely ANSI-SQL compliant statements, with one significant exception -- we used MySQL's group_concat function fairly frequently.  group_concat, by the way, does this: given a table of, say, employee names and projects...  SELECT empName, projID FROM project_members;   returns:  ANDY   |  A100 ANDY   |  B391 ANDY   |  X010 TOM    |  A100 TOM    |  A510   ... and here's what you get with group_concat:  SELECT      empName, group_concat(projID SEPARATOR ' / ')  FROM      project_members  GROUP BY      empName;   returns:  ANDY   |  A100 / B391 / X010 TOM    |  A100 / A510   So what I'd like to know is: Is it possible to write, say, a user-defined function in SQL Server which emulates the functionality of group_concat?   I have almost no experience using UDFs, stored procedures, or anything like that, just straight-up SQL, so please err on the side of too much explanation :)
Impulsioned jumping There's one thing that has been puzzling me, and that is how to implement a 'faux-impulsed' jump in a platformer. If you don't know what I'm talking about, then think of the jumps of Mario, Kirby, and Quote from Cave Story. What do they have in common? Well, the height of your jump is determined by how long you keep the jump button pressed.  Knowing that these character's 'impulses' are built not before their jump, as in actual physics, but rather while in mid-air - that is, you can very well lift your finger midway of the max height and it will stop, even if with desacceleration between it and the full stop; which is why you can simply tap for a hop and hold it for a long jump -, I am mesmerized by how they keep their trajetories as arcs.  My current implementation works as following:    While the jump button is pressed, gravity is turned off and the avatar's Y coordenate is decremented by the constant value of the gravity. For example, if things fall at Z units per tick, it will rise Z units per tick.  Once the button is released or the limit is reached, the avatar desaccelerates in an amount that would make it cover X units until its speed reaches 0; once it does, it accelerates up until its speed matches gravity - sticking to the example, I could say it accelerates from 0 to Z units/tick while still covering X units.  This implementation, however, makes jumps too diagonal, and unless the avatar's speed is faster than the gravity, which would make it way too fast in my current project (it moves at about 4 pixels per tick and gravity is 10 pixels per tick, at a framerate of 40FPS), it also makes it more vertical than horizontal. Those familiar with platformers would notice that the character's arc'd jump almost always allows them to jump further even if they aren't as fast as the game's gravity, and when it doesn't, if not played right, would prove itself to be very counter-intuitive. I know this because I could attest that my implementation is very annoying.    Has anyone ever attempted at similar mechanics, and maybe even succeeded? I'd like to know what's behind this kind of platformer jumping. If you haven't ever had any experience with this beforehand and want to give it a go, then please, don't try to correct or enhance my explained implementation, unless I was on the right way - try to make up your solution from scratch. I don't care if you use gravity, physics or whatnot, as long as it shows how these pseudo-impulses work, it does the job.  Also, I'd like its presentation to avoid a language-specific coding; like, sharing us a C++ example, or Delphi... As much as I'm using the XNA framework for my project and wouldn't mind C# stuff, I don't have much patience to read other's code, and I'm certain game developers of other languages would be interested in what we achieve here, so don't mind sticking to pseudo-code.  Thank you beforehand. try+gerund/infinitive (Difference in meaning) How to manage memory alignments and generic pointer arithmetics in a portable way in C? How to check if a String contains another String in a case insensitive manner in Java? What is the first reference to an internet of computers in science fiction? I bought a Mac (13", early 2011) almost 5 years ago. When I first got it, it was running under OS X 10.7 and it was pretty fast. I've being upgrading it ever since and it's now running under Mac OS X 10.11.  I guess it didn't totally survive the upgrades because, today, there's a lot of bugs, freezes, lags, "spinning beach ball" appearing,... for example, when I write something on a normal program/editor, the cursor freezes for a few seconds, then catches up to what I'm writting.  As you can guess, that's really annoying! I've been thinkning about upgrading the hardware but I don't know what to do: should I change the RAM to 8 GB - 1 333 MHz (currently my computer has 4 GB - 1 333 MHz)? Or should I upgrade to an SSD (which is pretty expensive and difficult to install)?  Thank you very much. Why does cancellation of dots $\frac{\partial \dot{\mathbf{r}}_i}{\partial \dot{q}_j} = \frac{\partial \mathbf{r}_i}{\partial q_j}$ work? Infinite Series $1+\frac12-\frac23+\frac14+\frac15-\frac26+\cdots$ Was given the following infinite sum in class as a question, while we were talking about Taylor series expansions of $\ln(1+x)$ and $\arctan(x)$: $$1+\frac12-\frac23+\frac14+\frac15-\frac26+\cdots$$  The question isn't homework or anything, just a thought tease. I tried for a long while but couldn't find anything remotely close. Thanks in advance for the help. Total time derivatives and partial coordinate derivatives in classical mechanics If I could stop ALL motion would I stop time? I've never really understood time. Time is not a force. It isn't energy or matter. Time doesn't MAKE anything do anything. Time doesn't make a clock tick (motion or batteries do). Time doesn't make the earth revolve around the sun (motion/gravity does). I don't think time exists. People say time is used as a form of measurement but aren't we just measuring movement? Even atomic clocks measure the movement of electrons that orbit an atom's nucleus as they "jump" back and forth between energy states. So my question is if I were to stop ALL motion (even movement of electrons that orbit an atom's nucleus) would I stop time? Is time just masquerading as the measurement of motion?  EDIT: This question is not a duplicate of "Does time freeze at Absolute Zero?" Because I am NOT talking about temperature. I am speaking about the motion of ALL things. I am asking if ALL things (photons, energy, matter, forces) stop moving would time stand still? I would have to say yes it would. If ALL motion were to stop for a million years and then start again no one would even know. Atomic clocks wouldn't even miss a step. What point (pt) font size are \Large etc.? In the preamble I have:  \documentclass[a4paper,11pt]{article} \usepackage{fontspec} \setmainfont{Arial}   What can be inferred about the real font pt size for the following?  \tiny, \scriptsize, \footnotesize, \small, \normalsize, \large, \Large, \LARGE, \huge, \Huge Photoshop using Marque Tool > Path > Circular But Not a perfect shape? Please consider this image below :   This is happened when I have a circular shape (marquee tool selection). THen after that I converted to Work Path (by right click of that selection). And I add 2.0 as its Tolerance Pixel.   After applying it. The shape become not perfect, could you see the difference? I make it with a black background so everyone could see it from the image no.2.  I realized this is a problem, because If i use that path for placing a text. the text wont follow the correct path as circular (selection), instead ... the shape a bit changed (i think it's ugly shape :: see the detail of the arrow).  How to solve this case ? I'm using Photoshop CS3. 16.04 new installation gives grub-efi-amd64-signed failed installation /target/ ubuntu 16.04 at the end I am installing Ubuntu 16.04 in an Intel NUC computer with UEFI enabled. I am using an SSD from another computer. During the installation I chose Erase the disk and make a new full install  At the end of the process I see:  grub-efi-amd64-signed failed installation /target/ Ubuntu 16.04    And the system does not boot.  I tried to use boot-repair but apparently it does not solve the problem. Storing two kinds of point geometry in shapefile or creating multipoint shapefiles? Following , can I have a mixture of two kinds of geometry in a shapefile of type point. Just like I have about shapefiles of type polygon or I should always create a shapefile of type multipoint in order to support multipoints in my layer?    My problem is as you see at , I can't use ogrinfo in order to understand that the geometry type of a multipoint shapefile will be known as wkbMultipoint or wkbPointwhen I use this line of code:    OGRwkbGeometryType GeometryType = poLayer -&gt;GetGeomType();     for a layer of type multipoint before programming.     Will OGR know a layer of type multipoint as wkbpoint or wkbmultipoint?   When we create a shapefile in ArcCatalog, we have point and multipoint, but not multipolyline or multipolygon for polyline and polygon.Why? Is it possible to make the -init method private in Objective-C? I need to hide (make private) the -init method of my class in Objective-C.  How can I do that? Removing elements that have consecutive duplicates How can I remove a commit on GitHub? I have a following problem: when I plug-in my USB flash drive, it isn't shown in Windows Explorer or recognized by system at all. In device properties, it is shown as:     USB MEMORY BAR     There's no partitions on the drive, so I can't format it:    DISKPART:     Virtual Disk Service error:   There is no media in the device.   HP USB format tool:     There is no media in the specified device.   Any help will be greatly appreciated! Thank You! How to retrieve the first n characters of a variable in Bash? Why aren't Java Collections remove methods generic? Why isn't  generic?    Seems like Collection&lt;E&gt; could have boolean remove(E o);   Then, when you accidentally try to remove (for example) Set&lt;String&gt; instead of each individual String from a Collection&lt;String&gt;, it would be a compile time error instead of a debugging problem later.