I have a sql query which i managed to filter joining different tables, Below  NoOfCounts - Duplicate count of same Question in a Form having different Answer NoOfRowsPerAnserId - Used a Rank Partition by and order by AnswerId  My resultset looks somewhat like this now,  What I expect ( I just omitted other column but it can be there if this is not possible)  Query I have CREATE Table #myData ( Id INT Identity (1,1) ,NoOfCounts INT ,NoofRowsPerAnswerId_RankFunction INT, AnswerId INT, Value NVARCHAR(256) , FormId INT, QuestionId INT, AnserNameofItem NVARCHAR(256), DesiredValue NVARCHAR(256))  INSERT INTO #myData  VALUES (1,1,11,90,101,1,'Equity','')  ,(2,1,22,$1000,101,2,'CashInFlow','') ,(2,2,22,$1001,101,2,'CashOutflow','') ,(3,1,33,$99,101,3,'Chase','') ,(3,2,33,$100,101,3,'Capital','') ,(3,3,33,$101,101,3,'Citi','') ,(4,1,44,$800,101,4,'Equity','') ,(4,2,44,$801,101,4,'Fund','') ,(4,3,44,$802,101,4,'Credit','') ,(4,4,44,$804,101,4,'Debit','')   SELECT * FROM #myData
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 :)
What is the life expectancy of a Wookiee? At lunch, my coworkers and I were discussing The Force Awakens, and started questioning Chewbacca's age.  A quick check of  and it says he is possibly about 230 years old as of Episode VII.  Following the  link on that page, Wookieepedia claims that they live to be 400 years old.  Do we know from canon what the average life expectancy of a Wookiee is? Let $X \subset L^1(\mathbb{R})$ a closed linear subspace satisfying \begin{align} X\subset \bigcup_{p&gt;1} L^p(\mathbb{R})\end{align}    Show that $X\subset L^{p_0}(\mathbb{R})$ for some $p_0&gt;1.$   I guess the problem is that in infinite measure spaces the inclusion $L^p\subset L^q$ only holds for $p=q$. Is it maybe possbile to apply Baire's Theorem in some way? How to use PostgreSQL/PostGIS with ArcGIS for Desktop? How do I figure out if someone is a first cousin, second cousin, cousin once-removed, etc? The function auto.arima in the forecast package of R is a powerful tool to identify the best ARIMA(p,d,q) model for a given data series. In the   of the function, they report the following:  auto.arima(y, d=NA, max.p=5, max.q=5, max.order=5, max.d=2, start.p=2, start.q=2, ...)   According to the above function it seems that, by default, auto.arima tries to find the best model among all the combination having:   p equal or lower than 5 q equal or lower than 5 d equal or lower than 2 order equal or lower to 5, i.e. p + q + d  ≤ 5.   However, why does the default code stops at these conditions? Is there any particular reason why p, q and d should be equal or lower than 5, 5 and 2 and their sum lower than 5? Evaluating $\int \frac{1}{{x^4+1}} dx$ I am trying to evaluate the integral  $$\int \frac{1}{1+x^4} \mathrm dx.$$  The integrand $\frac{1}{1+x^4}$ is a rational function (quotient of two polynomials), so I could solve the integral if I can find the partial fraction of $\frac{1}{1+x^4}$. But I failed to factorize $1+x^4$.   Any other methods are also wellcome. I'm looking to have cell borders automatically applied when a cell is not empty. I thought I could use conditional formatting for this, but it doesn't seem to be an option. My Ubuntu 12.04 was normally updated through the Update Manager, something about gtk. Then I rebooted and now all that shows after the splash screen is a blue screen that only shows the cursor. How can I create a product key for my C# application? How can I create a product key for my C# Application? I need to create a product (or license) key that I update annually.  Additionally I need to create one for trial versions.  Related: Quotient group $G/H$ is abelian iff $[G,G] \subseteq H$ How do I change the background color of current buffer or pane in vim? I cannot mount Windows 8 partition disk on Ubuntu 12.10.  My Windows 8 is installed on "C" partition, and I have another "D" partition.  I can easily mount "D" partition, see files and make changes on them. Actually I also have a problem with this: when I copy a file from ubuntu to "D", I cannot see this file on Windows 8.  My main problem is when I try to mount "C" partition I get this:     Unable to mount 121 GB Volume   Error mounting /dev/sda3 at /media/furkan/06DEC78FDEC77589: Command-line `mount -t "ntfs" -o "uhelper=udisks2,nodev,nosuid,uid=1000,gid=1000,dmask=0077,fmask=0177" "/dev/sda3" "/media/furkan/06DEC78FDEC77589"' exited with non-zero exit status 14: Windows is hibernated, refused to mount.   Failed to mount '/dev/sda3': Operation not permitted   The NTFS partition is hibernated. Please resume and shutdown Windows   properly, or mount the volume read-only with the 'ro' mount option, or   mount the volume read-write with the 'remove_hiberfile' mount option.   For example type on the command line:           mount -t ntfs-3g -o remove_hiberfile /dev/sda3 /media/furkan/06DEC78FDEC77589 14.04 --> 16.04 failed; apt (>= 1.0.1ubuntu2.13)' is not installed Compiler error C3493: 'func' cannot be implicitly captured because no default capture mode has been specified For which values of $\alpha$ and $\beta$ does the integral $\int\limits_2^{\infty}\frac{dx}{x^{\alpha}\ln^{\beta}x}$ converge? Postgres JDBC connection in Eclipse Help I'm trying to get a postgres jdbc connection working in eclipse. It would be nice to use the Data Source Explorer, but for now I'm just trying to get a basic connection. What I have done so far is download the postgres JDBC connector. I then tried two different things. First, Preferences-> Data Management, I tried to add the postgres connector. Second, I added the jar to my project and tried to load the driver using Class.forName("org.postgresql.Driver"); but neither worked. Does anyone have any ideas?  Thanks,    Charlie made me think about the movie versions of the 7th book.  In Deathly Hallows Part II      Voldemort has Nagini attack Snape because Voldy thinks that Snape has the Elder Wand's allegiance. We know that Snape didn't actually have the allegiance, Draco did (and by then Harry did) and his plan had failed.   But if Voldy's plan had succeeded with Snape, would he have gotten allegiance?      Since voldemort didn't kill Snape, Nagini did... If you're not used to seeing the 'low on internal storage' notification, what is it that you're doing to keep your phone's internal memory from filling up so quickly?   The 'SD Card and Phone Storage' menu in the settings doesn't really tell me much other than how much is free. And, I don't really have that many applications installed. The top 5 storage hogging apps on my phone are Gmail (18.6 MB), Twitter (17.5 MB), Facebook (12.55 MB), Maps (9.63 MB), and Swype (6.06 MB).  So, are there apps out there (besides your normal file manager ones, like Astro) that will help monitor internal phone storage? Is there something I should be doing to keep my phone storage use to a minimum? JavaScript open in a new window, not tab I have a select box that calls window.open(url) when an item is selected.  Firefox will open the page in a new tab by default.  However, I would like the page to open in a new window, not a new tab.    How can I accomplish this? Why doesn't the tilde (~) expand inside double quotes?