I have transaction table proposal_header and the detail table is proposal_item, what I need is to get concatenated tender_number grouped by detail_number in proposal_item, but I don't get it how to concatenate it, how the query should be?  the proposal_header table is :  id  tender_number 7   BS7 12  BS12 14  CS14   the proposal_item table is:  proposal_header_id  detail_number   7                161932   7                161929   12               161932   12               161929   14               334659   and then i have joined:  select b.id as mainId,a.detail_number ,b.tender_number from dbo.proposal_header b inner join dbo.proposal_item a on a.proposal_header_id =b.id   the result of join is:  main Id  detail_number  tender_number 7        161932         BS7 7        161929         BS7 12       161932         BS12 12       161929         BS12 14       334659         CS14    but what i need, is only detail number and concate tender number, is there a solution to make it like this ?  detail_number  tender_number 161932          BS7, BS12 161929          BS7, BS12 334659          CS14
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 :)
Google map only loading half of itself Real definition of "countable set" I use a Windows 10 machine remotely at work. Both the local and remote machine are in the same ISP network (not same local network, but same ISP). I've been using it like that for almost a year now and I had never experienced absolutely any issues.  Until recently. I don't know if anything specific triggered this behavior, but I feel that it started happening after I upgraded the remote to W10 1903. I later upgraded the local one as well and I feel that it only made the problem worse (but I don't really have any data).  From time to time, the session will freeze - the image stops updating. However, what I type and mouse clicks are still being sent. No error message is shown whatsoever, the image simply freezes. To make it work again, I have to close and re-open the session. Everything that I had typed and/or clicked while it was frozen is there.  Is there any way I can debug this? This week we rolled out a series of changes to  of the question close workflow.  You can read more about the details of these changes .    For context, the overall effort to improve the question close experience will be optimized for Stack Overflow. Given Stack Overflow’s scale, many of the pain points we hear about with question closing and reopening are unique to Stack Overflow and won’t make sense for other network sites. However some  changes are general improvements that should improve usability and guidance overall. Wherever possible, we plan to roll these changes out network wide as well. Any time we roll out a change network wide, we’ll make sure to cross-post here. This first phase is being rolled out to the network and is why I’m posting today.  Let us know if you run into any issues or have questions regarding the network here. Better HTTPS support for Stack Exchange sites To date I have had an Apple ID tied to my personal email address. It uses my personal paypal account for the purchases, and currently it has a credit balance thanks to some Christmas iTunes gift cards.  With the App Store recently being released, I'd like to buy an OS X app for business purposes. I don't want to use the credit balance on my personal Apple ID account, so I was thinking about creating a new Apple ID just for when I buy apps that I use for business. This way I could have the business Apple ID tied to my business paypal account.  However, I'm concerned that there might be some gotchas with using two different Apple IDs on the same MacBook by the same user. Before I just try this blindly, does anyone have any experience or know of any gotchas? I'm using Ubuntu 14.04 but since some weeks I'm stuck with the old 13.10 lockscreen design for some reason.  I already tried compizconfig-settings-manager but it doesn't offer me any option for changing the lockscreen design and even resetting Compiz and Unity with   dconf reset -f /org/compiz/   didn't help.  Are there any other ways to get the new lockscreen back? Can the coefficient of static friction be less than that of kinetic friction? It is well known that compactness implies pseudocompactness; this follows from . I know that the converse does not hold, but what is a counterexample?  (A  is a topological space $S = \langle X,{\mathfrak I}\rangle$ such that every continuous function $f:S\to\Bbb R$ has bounded range.) I wish to show that $\mathbb{Q}(\sqrt2, \sqrt3)$ is not isomorphic to $\mathbb{Q}(\sqrt[4]2)$.    What I did so far was to show that $\mathbb{Q}(\sqrt2,\sqrt3) =\text{span}\{1,\sqrt2,\sqrt3,\sqrt6\}$.  Assuming they are isomorphic, denoting $f$ the isomorphism, then $f(1) = 1$, so $x^2-3$ has a root in $\mathbb{Q}(\sqrt2,\sqrt3)$ so $\sqrt 3\in\mathbb{Q}(\sqrt[4]2)$. ($\sqrt2 \in \mathbb{Q}(\sqrt[4]2)$, $\sqrt[4]2\cdot\sqrt[4]2=\sqrt2)$.   Thus under the assumption, $\mathbb{Q}(\sqrt2, \sqrt3)\subseteq \mathbb{Q}(\sqrt[4]2)$. As a vector spaces of the same dimension over $\mathbb{Q}$, it means that $\mathbb{Q}(\sqrt2, \sqrt3)= \mathbb{Q}(\sqrt[4]2)$.  Now all is left to do it to show a contradiction: $\sqrt[4]2\in\mathbb{Q}(\sqrt2,\sqrt3)$, then $\sqrt[4]2 = a+b\sqrt2+c\sqrt3+d\sqrt6$ so $2=(a+b\sqrt2+c\sqrt3+d\sqrt6)^4$, I believe that opening the expression, I would find out that it can't be an element of $\mathbb{Z}$. However this is a really inelegant way (if it really works), and I wish for a better way to do so.  An other approach: $\mathbb{Q}(\sqrt2,\sqrt3) = \mathbb{Q}(\sqrt2 + \sqrt3)$ by the irreducibility of $x^4-10x^2+1$ over $\mathbb{Q}$ (an some dimension theorem usage). Also, $x^4-10x^2+1$ splits in $\mathbb{Q(\sqrt2, \sqrt3)}$.   Is there a way to show that this polynomial doesn't split over $\mathbb{Q}(\sqrt[2]4)$? with different method then assuming that $\sqrt3\in\mathbb{Q}(\sqrt[4]2)$ and getting a contradiction? Maybe the fact that $\sqrt[4]2$ has complex roots might help? Simple property of a valuation on a field Vertically align text next to an image? How can I copy the path to a folder or a file? The Info Dialog doesn't allow me to copy the information that stands there ...    Is there an easy way to do this? What is the best (or preferred method) of setting a url parameter on a visualforce page embedded on a standard layout page?    This is easy to do when creating a custom link or a button, but I don't get how to do this on page load via the Apex Controller for the page.   When using a custom button you can do something like /apex/MyPageName?parameter=value  Can I use something like this?   ApexPages.currentPage.getParameters().put('Id',myId) How do I perform an IF...THEN in an SQL SELECT? How do I perform an IF...THEN in an SQL SELECT statement?  For example:  SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product To convert an MKV to AVI, I do two things. The first thing I do is this:  ffmpeg -i filename.mkv -vcodec copy -acodec copy output.avi   or this:  ffmpeg -i filename.mkv -sameq -acodec copy output.avi   Either of these will convert the MKV to an AVI, but the problem is that the video does not play smoothly for some reason. That's fine though, because if I do one more thing it gets fixed:  ffmpeg -i output.avi -vcodec mpeg4 -b 4000k -acodec mp2 -ab 320k converted.avi   After I do this then the file plays without problem. I had success doing it this way for one file, but then I tried it on another file, and there is a slight, but noticeable loss in video quality. This is the output I get when doing the second step:  FFmpeg version 0.6.1, Copyright (c) 2000-2010 the FFmpeg developers   built on Dec 29 2010 18:02:10 with gcc 4.2.1 (Apple Inc. build 5664)   configuration:    libavutil     50.15. 1 / 50.15. 1   libavcodec    52.72. 2 / 52.72. 2   libavformat   52.64. 2 / 52.64. 2   libavdevice   52. 2. 0 / 52. 2. 0   libswscale     0.11. 0 /  0.11. 0  Seems stream 0 codec frame rate differs from container frame rate: 359.00 (359/1) -&gt; 29.92 (359/12) Input #0, avi, from 'output.avi':   Metadata:     ISFT            : Lavf52.64.2   Duration: 00:04:17.21, start: 0.000000, bitrate: 3074 kb/s     Stream #0.0: Video: mpeg4, yuv420p, 704x480 [PAR 229:189 DAR 5038:2835], 29.92 fps, 29.92 tbr, 29.92 tbn, 359 tbc     Stream #0.1: Audio: vorbis, 48000 Hz, stereo, s16 Output #0, avi, to 'converted.avi':   Metadata:     ISFT            : Lavf52.64.2     Stream #0.0: Video: mpeg4, yuv420p, 704x480 [PAR 229:189 DAR 5038:2835], q=2-31, 4000 kb/s, 29.92 tbn, 29.92 tbc     Stream #0.1: Audio: mp2, 48000 Hz, stereo, s16, 320 kb/s Stream mapping:   Stream #0.0 -&gt; #0.0   Stream #0.1 -&gt; #0.1   I just used arbitrarily large settings on the second step and it worked nicely before but not in this case. What settings should I use? Add table row in jQuery What is the best method in jQuery to add an additional row to a table as the last row?  Is this acceptable?  $('#myTable').append('&lt;tr&gt;&lt;td&gt;my data&lt;/td&gt;&lt;td&gt;more data&lt;/td&gt;&lt;/tr&gt;');   Are there limitations to what you can add to a table like this (such as inputs, selects, number of rows)? I posted a question and a couple of respondents asked for the source code. I could only post portions of the code.  If attachments were allowed I could have uploaded a .zip file with the whole application.  Will this be a feature in SO? Move all files of type to a new folder in windows 7 Need rtl8814au driver for kernel 5.3 on Ubuntu 19.10