I have data in one field separated by comma "ID field " and I need to write each number in one column vertically the data as below:   YEAR   WEEK BADGE   Name    remarks         BT_Hrs  NoOfDays    id 2017    1   1111    emp1    test1            36       4         440,824,104,412,741,900,000   the table needed as below   2017    1   1111    emp1    test1   36  4   440 2017    1   1111    emp1    test1   36  4   824 2017    1   1111    emp1    test1   36  4   104 2017    1   1111    emp1    test1   36  4   412 2017    1   1111    emp1    test1   36  4   741 2017    1   1111    emp1    test1   36  4   900 2017    1   1111    emp1    test1   36  4   000
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 :)
How can I print a variable with padded center alignment? How can I find the following limit :$$\lim_{n\to\infty}\left(1-\frac{1}{3}\right)^2\left(1-\frac{1}{6}\right)^2\left(1-\frac{1}{10}\right)^2\cdots\left(1-\frac{1}{\frac{n(n+1)}{2}}\right)^2$$There are four options $(a)\frac1{3}(b)\frac1{9}(c)\frac1{81}(d)0$ Thanks! Distribution of Product of Random Variables with one being the normal distribution. If G is a group, prove that $(ab)^n =a^nb^n$ implies G is abelian. I need to prove the equivalence of the following two statements, if $G$ is a group:     $G$ is abelian $\Leftrightarrow$  for each $a,b$ in $G$: $(ab)^n = a^n b^n$ for each integer $n$   I have done the $\Rightarrow$ implication, but I have no idea how to approach $\Leftarrow$, any hints are very welcome. Refresh Icon Cache Without Rebooting Normally, to refresh the icon cache in Windows, we have to reboot.  Is there a way to refresh the icon cache in Windows 7/8 without rebooting? Remove Actions/Filters added via Anonymous Functions That's a freaking bad practice I must say. Spent last two hours finding a solution to remove actions and filters added via Anonymous functions.    This is the code used on a Parent Theme, and I need to remove it.  /**  * Add custom columns to admin comments grid  *  * Rate that user set.  */ add_filter( 'manage_edit-comments_columns', function( $default ) {     $columns['smr_comment_rate']  = __( 'Rate', 'txtdmn' );      return array_slice( $default, 0, 3, true ) + $columns + array_slice( $default, 2, NULL, true ); });   Got , played with it heavily, but no help. So, is there any other alternative that will remove actions/filters added via anonymous functions?  Thanks I know how to define a package or a class, but how do I make it available (to myself) at all times?  Say I have the package file commonstuff.sty (or myprettyclass.cls), that I want to be able to include in any .tex file I create on my computer. Where do I put it? Do I need to run some installer on it, or is it enough to keep it in a certain folder?  Note: I know I can just place it in the same folder as the .tex file, but that's not what I'm after here. I'm looking for a way to "install" the package centrally on my computer. What is projection of WGS84 in GIS software? WGS84 is a reference ellipsoid that determines coordinates of every point on Earth using latitude, longitude and height about the its surface.  This ellipsoid is often used as a base to make maps. Though, to make a map on a flat paper or a flat digital screen you need a projection too. An example of a popular projection would be UTM.   Mainstream GIS software give plethora of projection alternatives to display your data layers. Among them, they also let you display your data using WGS84 only.  I think they are using a certain projection but what projection is that? mysql_fetch_array does not retrieve all rows Proving an identity for Bernoulli polynomials Consider the Bernoulli polynomials $B_n(x)$ given by the expansion  $$\frac{te^{xt}}{e^t-1} = \sum\limits_{n=0}^{\infty}B_n(x)\frac{t^n}{n!}.$$  I want to prove the identity $$B_n(1-x)=(-1)^nB_n(x).$$  This formula is given in a lot of books, but unfortunately without any proof. Therefore I'm wondering how to prove it. Do you have any idea?  I tried for instance:  $\sum\limits_{n=0}^{\infty}B_n(1-x)\frac{t^n}{n!}=\frac{te^{-xt}}{e^t-1}e^t=\left(\sum\limits_{n=0}^{\infty}B_n(-x)\frac{t^n}{n!}\right)\sum\limits_{n=0}^{\infty}\frac{t^n}{n!}=\sum\limits_{n=0}^{\infty}\left(\sum\limits_{l=0}^n\binom{n}{l}B_{l}(-x)  \right)\frac{t^n}{n!}$.  Hence  $B_n(1-x)=\sum\limits_{l=0}^n\binom{n}{l}B_{l}(-x)$.  But I do not know how to proceed.  On the other hand I know that $B_n(x+1)-B_n(x)=n x^{n-1}$. Hence  $B_{n}(1-x)=B_{n}(-x)-n(-x)^{n-1}$. But again, I do not know how I can go further.   Hopefully someone can help me.  Best regards Showing equality of sequence of holomorphic functions to limit function if converges uniformly locally I do not know how to proof following question:  Let $D$ be a domain in $C$.  ${{f}_{n}}$ be a sequence of holomorphic functions on $D$ that converges uniformly locally to a function non-constant $f$. Show that for each $z\in D$, there is a sequence ${{z}_{n}}\to z$ as ${{f}_{n}}({{z}_{n}})=f(z)$ for all sufficiently large $n$.  Actually, I know that I should use an assumption such as: ${{f}_{n}}({{z}_{n}})\ne f(z)$  Therefore, there is compact set    that  $\left\| {{f}_{{{n}_{k}}}}({{z}_{{{n}_{k}}}})-f(z) \right\|&gt;\varepsilon $  Then I think I have to use Montel theorem, but I do not know how to show the contradiction. Is the question mark misused in affirmative sentences? We have a org wide email addressed which has been "Verified" into our sandbox. I understant org wide email addressed is unsupported metadata, so this was achieved as pre deployment step.   Into our repo, we have a workflow that send email alert to that org wide email address. "  Workflow   ... &lt;senderAddress&gt;noreply@mycompany.com.au&lt;/senderAddress&gt; &lt;senderType&gt;OrgWideEmailAddress&lt;/senderType&gt;    The problem we are facing is that we are still getting the following error even if this org wide email address is verified:      You must specify a verified Org Wide Email Address for this sender   type.   Is that a bug in the metadata api or expected behaviour ? Ideally we would like to not have to do that as a post deployment step.   PS: We are running DX under api version 43.0 Let $x_1,...,x_n$ be distinct integers. Prove that  $$\prod_{i&lt;j} \frac{x_i-x_j}{i-j}\in \mathbb Z$$   I know there is a solution using determinant of a matrix, but I can't remember it now. Any help will be appreciated. Understanding the Basic Context of Trusted Hosts I got the trusted host settings error.      The trusted_host_patterns setting is not configured in settings.php. This can lead to security vulnerabilities. It is highly recommended that you configure this. See Protecting against HTTP HOST Header attacks for more information.    I read the  but I'm not understanding some of the basic context.   Are the "trusted hosts" me and other administrators who want to be able to administer the site remotely?  If so, would I add my PC's domain to the trusted host list? I read it as a paperback around 2009ish. There are at least two books in the series. In the first book, we learn that the protagonist lives up in the mountains. Her people are distrusted by the people in the plains, and I think have either dark or olive skin. She leaves home to learn magic, something I think is rare in the world she lives in. When she arrives, there's a crazy power-hungry man at her destination and she has to hide who she is because otherwise he'd have her killed to prevent her from surpassing him. At some point, she winds up in a set of chambers set into the mountain where she finds a pool of water and carvings about dragons. Somehow, this leads into her learning to become a dragon, I think perhaps after meeting one. I want to say that the sequel got into her having dreams that turn out to be partly prophetic and partly communication.  One of the reasons the book sticks out in my memory is that, despite the mentions of the protagonists dusky skin, the cover depicts a fair-skinned blonde girl, I think holding a glowing globe of light. Find out which application listens to specific key bindings? How do I escape a single quote ( ' ) in JavaScript? If every eigenvector of $T$ is also an eigenvector of $T^{*}$ then $T$ is a normal operator Let $V$ be a finite-dimensional inner product space over $\mathbb{C}$ and $T: V \to V$ a linear transformation.   Show that if every eigenvector of $T$ is also an eigenvector of $T^{*}$ then $T$ is a normal.   We need to show that $\forall v \in V,\ TT^*v=T^*Tv$.  I started by picking $v$ to be an eigenvector of $T$, hence $Tv=\lambda_1 v$, and $T^*v=\lambda_2 v$. Therefore: $$TT^*v=T(\lambda_2 v)=\lambda_2 Tv=\lambda_1 \lambda_2 v=...=T^*Tv$$  But I'm stuck when $v$ is not an eigenvector.  (Also, this question is taken from a chapter about Jordan forms, but I can't see how it relates) Can I use Divine Intervention or Wish to regain Wish? After reading this question on , I started wondering if there are ways for them to regain that ability.  I figured a Divine Intervention is probably strong enough as that is a god's power, as well as a second caster casting wish to undo the first wish (and thereby undoing its effects).  Are these valid ways of regaining the ability to cast wish?