The following SQL Server query need help       select      JI.id, RBIEnvironment from    (select         issue,        case when cfname='RBI-Environment'                then customvalue               else null         end as 'RBIEnvironment'      from X) as CT where      CT.issue = JI.id group by      JI.id, RBIEnvironment   The issue is the CT table returns the data in following format  1   NULL 1   STG 1   PROD 2   SIT 2   DIT 3   SIT   Hence the outer query returns   1   NULL 1   STG 1   PROD 2   SIT 2   DIT 3   SIT   I need in following format  1   STG,PROD 2   SIT,DIT 3   SIT   Please use the same inner dynamic table as such as it contains some more columns which needs to be displaye din the resultselt .This inner table is linked with the outer table using the issue field and ID field respectively
I've got two tables:  TableA ------ ID, Name  TableB ------ ID, SomeColumn, TableA_ID (FK for TableA)   The relationship is one row of TableA - many of TableB.  Now, I want to see a result like this:  ID     Name      SomeColumn  1.     ABC       X, Y, Z (these are three different rows) 2.     MNO       R, S   This won't work (multiple results in a subquery):  SELECT ID,        Name,         (SELECT SomeColumn FROM TableB WHERE F_ID=TableA.ID) FROM TableA   This is a trivial problem if I do the processing on the client side. But this will mean I will have to run X queries on every page, where X is the number of results of TableA.   Note that I can't simply do a GROUP BY or something similar, as it will return multiple results for rows of TableA.   I'm not sure if a UDF, utilizing COALESCE or something similar might work?
When should I start an LLC for my side work? I am doing quite a bit of sidework this year and wondering at what point would it be a good idea to "start a business" and bill through that. How can I hire a professor to answer my advanced technical questions in a niche area? In short, How does one go about hiring a professor or someone really well established in their field for a private tutoring session?  I tried looking online but can’t find much, mainly websites for tutors that are practitioners or “experts” as in with with n years of experience at best. This doesn’t cut it at my level as I am a researcher with a PhD and already have published papers on my topic.   However, I am very passionate about my subject and always looking to grow. So I do have questions, very technical (in my case computer science) and would happily pay a fee for consulting with a professor in the field.  Any advice? What's the difference between Invoke() and BeginInvoke() Just wondering what the difference between BeginInvoke() and Invoke() are?   Mainly what each one would be used for.  EDIT: What is the difference between creating a threading object and calling invoke on that and just calling BeginInvoke() on a delegate? or are they the same thing? I was reading French's Vibrations &amp; Waves where he discusses Huygens-Frensel Principle.   The principle talks about how secondary sources give rise to secondary wavelets to form the displaced wavefront. However, any secondary source can form two wavelets one moving forward &amp; other towards the original source as pointed by French:     [...] The Huygen's construction would define two subsequent wavefronts , not one. In addition to a new wavefront farther away from the source, there would be another one corresponding to a wavefront back toward the surface, But we know this does not happen.    Then he writes:     If the Huygens way of visualizing wave propagation is to be acceptable, it must introduce the unidirectional property of a traveling wave. This can be achieved by requiring that the disturbance  starting out from a given point in the medium at a given instant is not equal in all directions. Specifically, if $O$ is the true original source ,&amp; $S$ is the origin of Huygens wavelet, &amp; $P$ is the point at which the disturbance is being recorded, then the effect at $P$ due to the region near $S$is a function of $f(\theta)$ of the angle $\theta$ between $OS$ &amp; $SP$.     I am not understanding how his reasoning actually averts the possiblity of formation of back-waves. Can anyone help me visualise what he is talking? How does his reasoning maintain the unidirectional propagation of waves? Can anyone explain his argument? 101 positive integers placed on a circle A Pigeonhole Principle problem:     101 positive integers are placed on a circle whose sum is 300. Prove   that it is possible to choose from these numbers some consecutive   numbers whose sum is equal to 200.   (I don't know if the word 'consecutive' is appropriate in this case ,I mean that these numbers follow each other on that circle) Basis for Skew Symmetric Matrix I'm trying to find a basis for the kernel for the following mapping:  Considering the linear transformation T: $M_{33} \rightarrow M_{33}  $ defined by $T(A) = .5(A + A^T)$. I know that this is basically asking for the basis under the condition that $T(A)=0$ which means that $A+A^T=0$ so $A^T = -A$.  I found that matrices that fit this condition are Skew Symmetric Matrices.  However, I'm not sure how to find the basis for the kernel of these matrices. "I who has" vs "I who have." Possible Duplicate:          Am aware it is correct to say "I have written..." and "I am a doctor who has writen..."  I have, however, severally come across the sentence "I, Tertius, who have written...". Shouldn't it be "I, Tertius, who has written..."? I have a Samsung Galaxy S5 duos with stock Android Marshmallow, and I'm considering encrypting my SD card to prevent access to its contents in case I lose my phone. The main reason of not doing this is that I'm not sure if there's a way to mount an encrypted SD card on Windows (or other desktop OS's)   When I encrypt the SD card on my Samsung Galaxy S5, is it using a known implementation of encryption, or is it something that only works on Android (or perhaps Samsung) phones?   I do not want to use USB connection to my phone to access my SD card, it's terrible. Mounting the SD card is much easier and faster and less annoying.   EDIT: just to clarify, I am NOT talking about adoptable storage. I want a portable encrypted SD card that can both be read on PCs and Android phones (i.e. I want to be able to remove the SD card from my phone, plug it into my PC, provide a password to decrypt and read/write it like any other SD card) How can I align a multiple-line footnote text right to the footnote mark? How can I have the following "footnote layout"?  Some Text Some Text Some Text Some Text² Some Text   2 FOOTNOTETEXT FOOTNOTETEXT FOOTNOTETEXT FOOTNOTETEXT FOOTNOTETEXT   FOOTNOTETEXT FOOTNOTETEXT FOOTNOTETEXT FOOTNOTETEXT FOOTNOTETEXT   My problem is that the footnote text starting with the second line is too far left.  \documentclass{article} \usepackage{blindtext}  \begin{document}     \blindtext\footnote{\blindtext} \end{document} I want to append several shapefiles in QGIS. The ftools 0.6.1 add-on is installed.   But under Vektor>Datenmanagement-Werkzeuge>Shapedateien zu einer zusammenführen (=append shapefiles) is only the possiblility to choose the Eingabedatei (input file) and the Ausgabedatei (output file) but not a further Datei (file) for the append itself? (Even though there are  several shapefiles in the same folder)  //Furthermore the icon "In neue Projektion exportieren" (export to new projection) is also not appearing under the: Vektor>Datenmanagement-Werkzeuge? Do I need a further add-on?//  Has anyone an idea why I can't choose a shapefile for the appending?  Thanks in advance! phil How to remove the "Could not connect to the iTunes store" error message when your network does not allow access to the iTunes Store I tried to open the door. I tried opening the door   We can use both infinitive and gerund with verb "try" as used in above sentences. Does it change the meaning of the  sentence if use gerund or infinitive?.(here i don't know if the meaning of sentences is changed.)     The same confusion arise in these two sentences.  1.I stopped seeing him. 2. I stopped to see him.(But in case of these two sentence i know the meaning is changed but don't know exactly what the change is). When doing a clean re-installation of El Capitan (highest supported version) from a bootable USB on an older Mac (MBP, 15-inch, Late 2008), I get this error:  An unexpected error occured while signing in. AMD-Action:authenticate:SP  The error shows up, while logging in with the Apple ID into the App Store in the installer.  I tried with different Apple IDs,  Also tried running these commands in the Recovery Terminal and restarting: csrutil clear csrutil enable Prove Equivalence Relation in G Hei, guys!  I'm having some trouble with the next problem:  Let $A$ and $B$ be subgroups of $G$. Show that $\sim$ is an equivalence relation when it is defined as follows: $g\sim g'\Leftrightarrow g' = agb$ for some $a$ from $A$, $b$ from $B$.  Should I prove this is valid for any a and b? It says for some elements a and b. But I might as well take the unit element.   Could you give me a clue on how to solve it?  Cheers! How much hard drive space do I need to install Windows 7 on my Mac via Boot Camp? I have a Macbook Air and would like to install Windows 7 on it via Boot Camp. How much hard drive space should I make sure to have free before doing this? Derivation of the formula for Ordinary Least Squares Linear Regression How was the formula for Ordinary Least Squares Linear Regression arrived at?  Note I am not only looking for the proof, but also the derivation. Where did the formula come from? In the Avengers movie, why is Hulk's behaviour inconsistent? In the Avengers movie, when      Bruce Banner is on the helicarrier, he becomes angry and transforms into the Hulk. Black Widow happens to be next to him and even though both are on same team, he attacks her and then Thor.  He becomes hostile to everyone on the ship.  But later on, in the fight against Chitauri troops, Hulk is very comfortably self-controlled.    Why is that?    The only thing I could think of is that it has been many days (a year?) since the Hulk had gotten angry, so he couldn't control himself.    But that's lame to be so puny when Bruce Banner was compared to Stephen Hawking in intelligence. tabular input by columns (i.e. transpose a table) I would like to be able to transpose a tabular(x) table like in the following example. It is not necessary to be completely automated, but I don't want to change the data order, which is a painful and stupid. By "not completely automated" I mean that e.g. the headers can be done seperately etc.  Let's see the MWE:  \documentclass{article}  \usepackage{booktabs} \def\Midrule{\midrule[\heavyrulewidth]}  \begin{document}  \centering  \begin{tabular}{*6c}\toprule \bfseries Name &amp; Alice &amp; Bob &amp; Chuck &amp; Dave &amp; Eve\\\Midrule \bfseries Sex &amp; Female &amp; Male &amp; Male &amp; Male &amp; Female\\\midrule \bfseries Age &amp; 18 &amp; 19 &amp; 20 &amp; 21 &amp; 22\\\bottomrule \end{tabular}  \bigskip  Which I want to look like  \bigskip  \begin{tabular}{*3c}\toprule \bfseries Name &amp; \bfseries Sex &amp; \bfseries Age\\\Midrule Alice &amp; Female &amp; 18\\\midrule Bob &amp; Male &amp; 19\\\midrule Chuck &amp; Male &amp; 20\\\midrule Dave &amp; Male &amp; 21\\\midrule Eve &amp; Female &amp; 22\\\bottomrule \end{tabular}   \end{document}     Note: I know that , but I would like to get it without expl3 (mostly because people would might use my code quite often have an old LaTeX installed and I cannot be convincing them to change this). I'm having an issue with blender where whenever I try to render as any sort of video, instead of showing up as an mp4 or whatever file type I chose, it will show up as a mystery file that cannot be opened. This issue started recently and randomly: I was always able to render perfectly fine before and I used the exact same settings now that I did then.   not sure exactly what I'm doing wrong. Here are the export settings I am using: This is a homework question of mine that Ive answered and I'd really like some feedback on my solution.       Prove or find a counter example to the claim that for all sets $A,B,C$, $$\text{if  }A\cap B=B\cap C=A\cap C=\emptyset \text{ then } A\cap B\cap C\neq \emptyset$$.   Since I can only either prove it is true, OR find a counter example I have gone with the latter because I think this statement is not true. My counter example is as follows:  Let $A = \{1,2,3 \}$ , $B = \{4,5,6 \}$ and $C = \{7,8,9 \}$. It is then clear that $A ∩ B =  B ∩ C =  A ∩ C = \emptyset$ .  If we let $x ∈ A\cap B\cap C$ then $x$ must be in $A$ and $B$ and $C$. Since this cannot be possible because there are no common elements then this implies that $A∩B∩C$ has to be equal to a null set i.e $A∩B∩C = \emptyset$ and thereby showing that (at least for this scenario) if $A \cap  B =  B \cap  C =  A \cap  C = \emptyset$ then $A\cap B\cap C = \emptyset$.  Is this okay? Any feedback will be greatly appreciated thank you!