I want to pass a csv of int  1,2,3,4,5,6,7   to a stored procedure so that I can use the passed-in values in an IN() so that   IN(1,2,3,4,5,6,7)   Is that even possible?
Possible Duplicate:          I have seen  in SQL. I wonder how would you approach the opposite problem: splitting coma delimited string into rows of data:  Lets say I have tables:  userTypedTags(userID,commaSeparatedTags) 'one entry per user tags(tagID,name)   And want to insert data into table  userTag(userID,tagID) 'multiple entries per user   Inspired by  question  EDIT  Thanks for the answers, actually more then one deserves to be accepted but I can only pick one, and the  with recursions seems pretty clean to me. It works on SQL Server 2005 and above.   For earlier version of SQL Server the solution  can be used.  For working with text data type  will be helpful. Thanks again.
Separator between command list and } Any practical uses of machine learning for cryptography? How to know the types of windowing system, window manager and desktop environment of a Unix-like OS How do I get HTML5 h.264 Video working on Firefox? According the the , h.264 video should now be working in Linux.  It does also say the appropriate gstreamer plug-ins need to be installed.  Does anyone know what these are?    I used this  and the  to verify that h.264 support works in Google Chrome on my Ubuntu 12.04 64-bit, but does not work on Firefox 26. How to identify the process locking a file? Can I travel to Croatia with single-entry Schengen visa? I am traveling to Zurich with a single-entry Schengen visa.  While coming back can I travel to Croatia for 3 days and then return to India (Country of Origin)? When we find the electric field between the plates of a parallel plate capacitor we assume that the electric field from both plates is $${\bf E}=\frac{\sigma}{2\epsilon_0}\hat{n.}$$ The factor of two in the denominator comes from the fact that there is a surface charge density on both sides of the (very thin) plates. This result can be obtained easily for each plate. Therefore when we put them together the net field between the plates is $${\bf E}=\frac{\sigma}{\epsilon_0}\hat{n}$$ and zero everywhere else. Here, $\sigma$ is the surface charge density on a single side of the plate, or $Q/2A$, since half the charge will be on each side.   But in a real capacitor the plates are conducting, and the surface charge density will change on each plate when the other plate is brought closer to it. That is, in the limit that the two plates get brought closer together, all of the charge of each plate must be on a single side. If we let $d$ denote the distance between the plates, then we must have $$\lim_{d \rightarrow 0}{\bf E}=\frac{2\sigma}{\epsilon_0}\hat{n}$$ which disagrees with the above equation. Where is the mistake in this reasoning?  Or more likely, do our textbook authors commonly assume that we are in this limit, and that this is why the conductor behaves like a perfectly thin charged sheet? I know that for every $n\in\mathbb{N}$, $n\ge 1$, there exists $p(x)\in\mathbb{F}_p[x]$ s.t. $\deg p(x)=n$ and $p(x)$ is irreducible over $\mathbb{F}_p$.     I am interested in counting how many such $p(x)$ there exist (that is, given $n\in\mathbb{N}$, $n\ge 1$, how many irreducible polynomials of degree $n$ exist over $\mathbb{F}_p$).   I don't have a counting strategy and I don't expect a closed formula, but maybe we can find something like "there exist $X$ irreducible polynomials of degree $n$ where $X$ is the number of...".  What are your thoughts ? How can I change what keys on my keyboard do? (How can I create custom keyboard commands/shortcuts?) Is [Its'] a word? (Note the apostrophe at the end.) I just had a strange flashback to a conversation I had when I was in high school, with a man who was regarded by many members of a particular online community as having an impressive degree of knowledge of the English language.  The conversation centered on a claim this man made that I found very difficult to accept. I had made some remark involving the difference between it's and its (a distinction which I trust is quite well-known to the majority of users on this site), to which he had contributed, mostly phrased as an amusing aside, that there was one more word I hadn't mentioned: its', with the apostrophe at the end.  I originally thought he might have been joking, but we ended up debating this rather fervently. I seem to recall that I kept demanding he use the word in an example sentence, but he either could not or refused to do so. Yet he maintained that it is a word.  Is this true? I must concede I haven't put a lot of thought into it just now; but at the time, I was perplexed by the very suggestion that it could be a word (what could it mean?), and at the moment I can't really think of any scenario where it would make any sense. Can I attack a specific player? I was in a clan and someone kicked me from it.   I think I'm stronger than him. Is there any way I can attack him? The only method I see to attack is random players. Can I attack a specific player? Generating samples from singular Gaussian distribution Let random vector $x = (x_1,...,x_n)$ follow multivariate normal distribution with mean $m$ and covariance matrix $S$. If $S$ is symmetric and positive definite (which is the usual case) then one can generate random samples from $x$ by first sampling indepently $r_1,...,r_n$ from standard normal and then using formula $m + Lr$, where $L$ is the Cholesky lower factor so that $S=LL^T$ and $r = (r_1,...,r_n)^T$.  What about if one wants samples from singular Gaussian i.e. $S$ is still symmetric but not more positive definite (only positive semi-definite). We can assume also that the variances (diagonal elements of $S$) are strictly positive. Then some elements of $x$ must have linear relationship and the distribution actually lies in lower dimensional space with dimension $&lt;n$, right?  It is obvious that if e.g. $n=2, m = \begin{bmatrix} 0 \\ 0 \end{bmatrix}, S = \begin{bmatrix} 1 &amp; 1 \\ 1 &amp; 1\end{bmatrix}$ then one can generate $x_1 \sim N(0,1)$ and set $x_2=x_1$ since they are fully correlated. However, is there any good methods for generating samples for general case $n&gt;2$? I guess one needs first to be able identify the lower dimensional subspace, then move to that space where one will have valid covariance matrix, then sample from it and finally deduce the values for the linearly dependent variables from this lower-dimensional sample. But what is the best way to that in practice? Can someone point me to books or articles that deal with the topic; I could not find one. How to obtain and use the .bbl file in my tex document for ArXiv submission? Take into account all of the reputations from all stackexchange sites Prove every element of $G$ has finite order. Let $G$ be a group such that the intersection of all its subgroups which are different from $\{e\}$, is a subgroup different from $\{e\}$. Prove that every element of  $G$  has finite order.  Assume that $a$ has infinite order in $G$. Then let $y\neq e$ belong to the intersection of all subgroups of $G$ different from $\{e\}$. Then $y=a^n$ and $y$ will also belong to subgroup generted by $a^2$ hence  $y=a^{2m}$ for some integers $m$. This contradicts that $a$ has infinte order.  Is this correct? In Hitchcock's Vertigo, there is one part of the film that has never made sense to me and I believe that it was a cheap ploy to mislead the audience until the ultimate reveal (I won't spoil it here).    In this scene Jimmy Stewart watches Kim Novak enter a rooming house and afterwards sees her standing by the window on the 2nd floor.  When he enters the house and talks to the inn-keeper, she tells him that Kim Novaks's character positively never came in and even shows him her room key that is still behind the front desk.  They go up to the room and find it empty.   This scene seems to imply that the Kim Novak character may have had a ghost like quality. But given the reveal at the end she clearly does not and there was no way for her to enter the room without a key and without being seen by the inn-keeper.  If this was done by some other director I probably wouldn't have given this much thought but Hitchcock was a perfectionist (especially for this film) so I never understood the significance of this scene other than to mislead the audience (with a cheap ploy IMO).  Does anyone who is familiar with this film have a different explanation/perspective about this scene in an otherwise brilliant movie. What are the regulations for transporting medication abroad? This is in reference to medications, both prescription and non-prescription, not illicit drugs. Since the legality may vary on country, let's say a round trip from the US to Singapore, as an example.  When travelling with prescription medication, I am aware that you are supposed to bring your prescription with you. What about over-the-counter medication, such as Tylenol/aspirin? How about medication which is restricted or prescription-only in one country, yet available OTC in another (think Viagra)? In preparation for the eventual deployment of full HTTPS support on Stack Exchange, and also to make the currently available "alpha" HTTPS support more usable, all links from Stack Exchange sites to other Stack Exchange sites should be .  Currently, at least the following places still feature links with explicit http: protocol prefixes:   the page footer, the "Hot Network Questions" and "Community Bulletin" modules in the sidebar,  (the site switcher menu is OK, though),   and, of course,   lots and lots of user-supplied links in post and comment content.   I've posted this feature request with the intent to provide a single central place for tracking these issues, rather than having them scattered across multiple meta threads.  If you find more places on SE where protocol-relative links should be used, please report them below.  I fully expect this request, in its full sense, to be treated as  for the time being; however, these issues do need to be fixed at some point before our HTTPS support is ready for "prime time".  Ps. Yes, the next release of  (v1.10) is going to include a general client-side fix for most of these issues.  In the mean time, the  plugin effectively provides the same functionality, and much more besides. The app forgets that I voted when I scroll the question Related:   I am using 1.0.71 on KitKat.  Immediately after voting, the arrow is displayed in red and the vote count is correct. However, when I scroll to read answers and then back to the top, the arrow is grey again and the vote count is reset to the previous value.  A reload of the question (pulling the finger down) is needed to show the correct situation, which is kept from then on.  This case was on security.stackexchange.com but I observed the same behavior on other sites too.  Screenshots   original state:  upvoted:  scrolled down and back up  after a reload Say I had a Core i7 Laptop with 16GB of RAM and a 750gb drive.  Is there a mechanism where I can partition the HD into a Linux, Windows, OS X, Shared Data, Hypervisor setup where I boot a small hypervisor. I can start/stop a linux, Windows and OS X virtual machine and interact with them all from the hypervisor?   Code, Test, etc?  is this a type 1 Hypervisor?  I suppose I could run a small linux install and VmWare but could VmWare read the virtual machines from a physical hard disk partition versus a file based setup (.vmdk files)?