I have two SQL Server tables, EmployeeMst and EmployeeHistory  EmployeeMst is my master table, and EmployeeHistory is my record table.  I store comma-separated values in EmployeeHistory  Now I want to get employee names with use of a T-SQL query  My table EmployeeMst  EmpNo   EmpName --------------------- 1       abc 2       xyz 3       apple 4       banan 5       apk 6       ico 7       exe 8       botle 9       dev 10      tbl 11      col 12      fun 13      dbo 14      xnb 15      png 16      jpgn 17      pngns 18      dknd 19      dnckd 20      dnicnd   EmployeeHistory:  EmpYear    EmpNo --------------------------------- 2010       1,2,3,10,11,12,13 2011       1,2,3,4,5,6,16,17,18   Now i want output as below  OUTPUT:  EmpYear  EmpNo   EmpName 2010      1       abc 2010      2       xyz 2010      3       apple 2010      10      tbl 2010      11      col 2010      12      fun 2010      13      dbo 2011      1       abc 2011      2       xyz 2011      3       apple 2011      4       banan 2011      5       apk 2011      6       ico 2011      16      jpgn 2011      17      pngns 2011      18      dknd   There are so many comma-separated values in EmpNo column
Using SQL Server, how do I split a string so I can access item x?  Take a string "Hello John Smith". How can I split the string by space and access the item at index 1 which should return "John"?
Why I can't edit "Your Communities" list in stackexchange.com and Area 51? I can edit &quot;YOUR COMMUNITIES&quot; in the upper left drop-down menu from any of my communities: (e.g. )    But in  portal there's no &quot;edit&quot; link:    Why is that and how can I edit the list in  portal? Android reading from .txt File created in src folder How do we know the brain flips images projected on the retina back around? I made an svg in Illustrator, but now I want to use it in a website/app but it's a huge size (around 10 MB) how can I decrease the size of it? My illustrator file is pretty big but that because I have some tracing elements underneath. The file also has a big artboard, but when I save should I delete my tracing elements, and decrease the artboard size? Showing order of $Z (G) =1$ or $pq$ Extracting only the BibTex records relevant to the paper My colleague asked me to write a page for a paper he writes. I wrote the page in LyX, compiled it to LaTeX, and sent him the TeX files. Then he reminded me that I forgot to send the .bib file with all the references.  But, my .bib file is huge - it contains over 1000 references (I have a global BiBTeX file for all my papers). The page I wrote uses only about 20 of them.  Is there an automatic way to extract from the bib file, only the records relevant to the current paper? I just installed Ubuntu and it is great.  However, I installed in beside the Windows Vista OS.  I now want to remove Windows in an effort to improve performance.  What is the easiest way to do this? How to read dash files Should I vote to close a duplicate question, even though it's much newer, and has more up to date answers? How can I stop the symbolic x coords to be plotted twice? I have created a bar diagram similar to:   But at a certain width the symbolic x coords are plotted twice. How can I manage the x axis correctly?  Here is my mini example:  \documentclass[12pt,a4paper,]{scrartcl} \usepackage{a4wide} \usepackage[utf8]{inputenc} \usepackage[T1]{fontenc} \usepackage[ngerman]{babel} \usepackage{graphicx} \usepackage{tikz} \usepackage[miktex]{gnuplottex}  \usepackage{pgfplots}    \begin{document}     \begin{figure}         \begin{tikzpicture}         \begin{axis}[%         width=1\linewidth,         height=0.5\linewidth,         axis x line=center,         axis y line=left,         symbolic x coords={CP-Schelle,Mistel-Schelle V2,Mistel-Schelle V4,Mistel-Schelle V4.2D,Gewickelt nach Inspire},         enlargelimits=true,         ymin=0,         nodes near coords,         x tick label style={         font=\small,         text width=1cm,         align=center         },         ybar]         \addplot[color=gray, fill] coordinates {(CP-Schelle,1.000)};         \addplot[color=blue, fill] coordinates {(Mistel-Schelle V2,2.459)(Mistel-Schelle V4,3.318)(Mistel-Schelle V4.2D,2.243)(Gewickelt nach Inspire,1.782)};         \end{axis}         \end{tikzpicture}     \end{figure}      \begin{figure}         \begin{tikzpicture}         \begin{axis}[%         width=0.6\linewidth,         height=0.5\linewidth,         axis x line=center,         axis y line=left,         symbolic x coords={CP-Schelle,Mistel-Schelle V2,Mistel-Schelle V4,Mistel-Schelle V4.2D,Gewickelt nach Inspire},         enlargelimits=true,         ymin=0,         nodes near coords,         x tick label style={             font=\small,             text width=1cm,             align=center         },         ybar]         \addplot[color=gray, fill] coordinates {(CP-Schelle,1.000)};         \addplot[color=blue, fill] coordinates {(Mistel-Schelle V2,2.459)(Mistel-Schelle V4,3.318)(Mistel-Schelle V4.2D,2.243)(Gewickelt nach Inspire,1.782)};         \end{axis}         \end{tikzpicture}     \end{figure}  \end{document} How to return to the GUI? I am very new to Linux and Ubuntu. I use Ubuntu 11.10.  I was trying to exit the X server (in order to install some Nvidia drivers) and I typed in the terminal:  sudo service lightdm stop   How can I return to the Ubuntu interface? Is it possible to get a list of most recently installed packages? How to run specific test cases in GoogleTest Does scikit-learn have forward selection/stepwise regression algorithm? I'm working on the problem with too many features and training my models takes way too long. I implemented forward selection algorithm to choose features.  However, I was wondering does scikit-learn have forward selection/stepwise regression algorithm? What is the meaning of "algebraically indistinguishable" I heard the term couple of times (in Field theory class and book), for example: The different roots of $p(x)=x^3-2$ are "algebraically indistinguishable".  I understand the meaning intuitively, but what does it really mean ? How do I change my Minecraft username? $\nabla U=0 \implies U=\mathrm{constant}$ only if $U$ is defined on a connected set? Auto-sort column Google Spreadsheet on incoming Google Form response How can I get the Google Spreadsheet to automatically order the incoming form responses alphabetically (2nd column)?   I know how to do this manually or by going in and editing a cell, but cannot get it to do this as an onevent for incoming response. Get Record Type Developer Name without SOQL Query Another question on almost sure and convergence in probability Convergence in probability implies convergence on a subsequence almost surely.  But this means we fix a subsequence, such that $X_{n_k}$ converges for almost every $\omega$, right? The subsequence we pick does not depend on the $\omega$ right?