If there is a table called employee  EmpID           EmpName ----------      ------------- 1               Mary 1               John 1               Sam 2               Alaina 2               Edward   Result I need in this format:   EmpID           EmpName ----------      ------------- 1               Mary, John, Sam 2               Alaina, Edward   Q: this record is in same Employee table. I have almost no experience using UDFs, stored procedures, I need to be done this thing through query.Is this possible without using UDFs, SP's.
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 :)
iCloud storage always full External hard drive and Recycle Bin behavior When my Seagate external hard drive is plugged in, its $RECYCLE.BIN folder automatically contains all the files contained in the Recycle Bin of the PC. Is it true that actually we don't have any Recycle Bin of external hard drive, rather it is the Recycle Bin of the PC? Why is it so? What is Reflection in Java Can anyone explain? There is no such thing as magnetism? Here's an interesting "proof" that there is no such thing as magnetism. I know the answer but I love this so much I had to ask it here. It's a great way to confuse people!  As we all know, $$\nabla \cdot\vec{B} =0$$ Using the divergence theorem, we find $$ \iint_S \vec{B} \cdot \hat{n} \, dS = \iiint_V \nabla \cdot \vec{B} \, dV = 0$$ Since $\vec{B}$ has zero divergence, there exist a vector function $\vec{A}$ such that $$\vec{B} = \nabla \times \vec{A}$$ Combining the last two equations, we get $$\iint_S \hat{n} \cdot \nabla \times \vec{A} \, dS = 0$$ Applying Stokes' theorem, we find $$\oint_C \vec{A} \cdot \hat{t} \, ds = \iint_S \hat{n} \cdot \nabla \times \vec{A} \, dS = 0$$ Therefore, $\vec{A}$ is path independent and we can write $\vec{A} = \nabla \psi$ for some scalar function $\psi$. Since the curl of the gradient of a function is zero, we arrive at: $$\vec{B} = \nabla \times \nabla \psi = 0,$$ which means that all magnetic fields are zero, but that can't be!  Can you see where we went wrong? I have 16GB RAM. Do I need 32GB swap? I read many places that the rule of thumb for swap space is to double the amount of physical RAM. However, 32 GB does seem a LOT. Do I need that much? Do I need it at all with this high amount of physical RAM? Up arrow under a sequence I have a Win/Ubuntu 11.10 dual-boot setup, where I am running the OSes on separate partitions of my laptop HDD. I assume the best method of uninstalling is 'simply' a matter of deleting the Ubuntu partitions -once I've made sure control is given to the Windows bootloader instead of grub after POST.  The question is: How do I do that?  Stuff I've tried:  I tried the boot-repair CD (), but that was a bit beyond my abilities to figure out if I could do it with that tool :/.  I also tried EasyBCD (). It couldn't identify my ext3 partitions, let alone change the bootloader.  Lastly, I tried installing startup-manager in Ubuntu, and using that to set the Win7 bootloader as default. But upon restart, it still loads grub. How prove :         $$ {31}^{11}&lt;{17}^{14} $$       help please! Pigeonhole-principle with two choices I am able to solve this sort of problem pretty easily.     An arm wrestler is the champion for a period of 75 hours. The arm   wrestler had at least one match an hour, but no more than 125 total   matches. Show that there is a period of consecutive hours during which   the arm wrestler had exactly 24 matches.   However this homework problem I can't seem to figure out.     Tyler has five weeks to prepare for his driver’s test. His mother   volunteers to ride with him for either 15 minutes or one half hour   every day until the test but not for more than 15 hours in all. Show   that during some period of consecutive days, Tyler and his mother will   drive for exactly 8.75 hours.   If I try doing it the same way as the first problem. I get $70$ pigeons and $95$ pigeon holes. I honestly don't know where to start with this problem. I thought that maybe I could assume that they only drove $.25$ hours on each day and prove that there is a period of consecutive days where they drove for exactly $8.75$ hours. Then I could say that we assume there is one day that they drove for $.5$ hours and work my way up, but I can't seem to get that to work either. Calculating a spherical polygon centroid Tensor product vs. Cartesian Product for composite quantum systems Specifying element type for DXF creation using ogr2ogr I am trying to create a DXF from a Polygon Shapefile using ogr2ogr:  ogr2ogr -f DXF parcels.dxf parcels.shp   The problem is that the polygons are written as hatch elements.    How do I specify that ogr2ogr should create LWPOLYLINE elements (Or any other )?  I have tried this from command line and from QGIS 'save as' option with the same result.  I don't remember this being an issue in the past, but seems like it started with GDAL version 1.10.x. I've been watching a lot of pro replays ever since the SC2 beta came out, and I've noticed that almost always, when Protoss research upgrades, the shields are the last research chosen. Why is that? Seems to me that if anything, shields should be the most important upgrade, as they affect all Protoss units and buildings. How do I attach rope to a mesh I am trying to make a pirate ship and am trying to attach rope to the sails. my rope is made using a path, and soft body physics. I can not find a way to attach my rope to the sail. and I can not use pinned vertices because this is not a cloth modifier. How can I use a variable in the replacement side of the Perl substitution operator? I have an old Facebook account that I created, uploaded a couple of photos and simply ignored (i.e. no friends added). Now, I can't remember the email address associated with the account and I don't remember the password either. How can I find out which email address I had associated with that account?  P.S. I have created a new Facebook account and my picture can be used to identify me (if I can get someone at Facebook to take a look). Other than that, I'm willing to have that old account deleted altogether if recovery isn't possible.  Is there a way to resolve this issue? LibVLC.NET in GTK# Am I being charged taxes on my grocery purchases at Walmart? Today, I only bought groceries at Walmart and noticed that there is no tax on groceries in California (Google tells me that this is perhaps true for whole of the US?)  So far I have always paid tax at Walmart for my grocery purchases, but that also included items like crackers, shampoo etc  Did Walmart charge me then only for the items that were not groceries, or if your cart has groceries + non-grocery items, you get charged tax on all of them?  Or is this a policy that varies by store, or cashiers' knowledge/discretion, etc?  Would people recommend for me to break down a single mixed purchase into two: one only having groceries and the other with the rest, or is this being paranoid?  My grocery purchases, every two weeks, amount to around $100+.  I pay 8.25% tax, so that is enough to get me free gas if I can figure this out! I'm having a hard time understanding how changing space means changing time. In books I've read people are saying "space and time" or "" but never explain what the difference is between the two concepts or how they are related.  How are the concepts of space, time, and space-time related? Algorithm to find the irreducible polynomial What algorithm can be used find an irreducible polynomial of degree $n$ over the field $GF(p)$ for prime $p$. The reason I ask is I want to make a program for finite field arithmetic, but creating a field $GF(p^k)$ requires finding a irreducible polynomial. (I'm mostly interested in $GF(2^k)$.)