I want to create a table valued function in SQL Server, which I want to return data in comma separated values.  For example table: tbl  ID | Value ---+-------  1 | 100  1 | 200  1 | 300       1 | 400    Now when I execute the query using the function Func1(value)  SELECT Func1(Value)  FROM tbl  WHERE ID = 1   Output that I want is: 100,200,300,400
Consider a database table holding names, with three rows:  Peter Paul Mary   Is there an easy way to turn this into a single string of Peter, Paul, Mary?
How to blur a texture node in cycles material? For a Cycles material I need to blur a texture. If the texture where a Texture Image node, I can blur the image before adding it but in my case I need to blur a Voronoi Texture and so I can't do it.  I have searched but I didn't find a blur node. Can this be achieved? How do I compare two string variables in an 'if' statement in Bash? How to evaluate environment variables into a string in Python? Accessing UI thread handler from a service Construction of a Borel set with positive but not full measure in each interval Inheriting constructors Failed to fetch jessie backports repository I'm using a docker image as a base for my own development that adds the jessie backports repository in its Dockerfile and uses that to install a dependency. This image uses the following command to add the repository:  echo "deb http://ftp.debian.org/debian jessie-backports main" &gt;&gt; /etc/apt/sources.list   The problem is that fetching packages from the backports repository now  fails with the following error (this used to work previously):  W: Failed to fetch http://ftp.debian.org/debian/dists/jessie-backports/main/binary-amd64/Packages 404  Not Found  W: Failed to fetch http://deb.debian.org/debian/dists/jessie-updates/main/binary-amd64/Packages  404  Not Found   I looked on that server, and those paths are indeed not present there.  I tried to figure out on the Debian backports site whether this particular repository should still be available, and I didn't find any indication that this was deprecated or something like that.  Is this a temporary issue with the repository, or is the jessie-backports repository not available anymore? And if this is not a temporary issue, what options do I have to use this or an equivalent repository without upgrading to the newer Debian stable version? Are enemies with immunity to the Poisoned condition unaffected by Contagion? After the , the spell  now inflicts the  condition upon a successful melee spell attack. The relevant spell text is below, with updated portions highlighted in bold:  Your touch inflicts disease. Make a melee spell attack against a creature within your reach. On a hit, the target is poisoned. At the end of each of the poisoned target's turns, the target must make a Constitution saving throw. If the target succeeds on three of these saves, it is no longer poisoned, and the spell ends. If the target fails three of these saves, the target is no longer poisoned, but choose one of the diseases below. The target is subjected to the chosen disease for the spell's duration. Since this spell induces a natural disease in its target, any effect that removes a disease or otherwise ameliorates a disease's effects apply to it.  The wording of the spell leads me to conclude that this spell still inflicts a disease, which has the immediate effect of poisoning the target. Therefore, even if a target has poison immunity, they will still make Constitution saves as designated to see if the disease takes effect. However, the line, &quot;At the end of each of the poisoned target's turns...&quot; also leads me to think that an enemy with poison-immunity cannot be the Poisoned target, therefore disallowing the remaining sequence of events. Are targets with immunity to the Poisoned condition therefore immune to contagion? I have designed a circuit where I want to give a pulse of very short duration using a switch. How can I implement it in spice. How to filter a list by hour Why does a cork ball float to the side of a glass as illustrated in the following GIF? What is the physical phenomenon behind this observation and why does it happen? I can't review posts anymore—was the minimum reputation changed? Is it just for me, or has the privilege to review new posts and late answers changed for everyone?  I recently started being more active in reviewing, but the rep requirement just shot up and I can not review anymore? The rep requirement has shot up to 500. Is this just for me, as a 'process", or has it been changed site wide? Can crumbled feta cheese last almost a year? talks about feta cheese in a brine or milk bath lasting up to three months.  What about crumbled feta?  I was looking through the fridge, and found a 1/2 pound open container of crumbled feta.  I have only used about an ounce of it.  There is no sign of mold on it, and it smells like feta cheese.  A small sample tasted okay.  The amazing thing is that I bought it in October or November: 8-10 months ago!  I have a recipe that calls for almost a 1/2 pound of feta, and I will be the only one eating it (so I'm not trying to impress anybody!).  I dislike wasting food, but I dislike being sick even more!  Is it safe to use dry crumbled feta that is so old? How to start X windows inside "Bash on Ubuntu on Windows" After installing the new feature (still "Beta") called  that is a feature subset of Windows 10 Anniversary edition, I get the following message when trying to start X-Windows using startx :    What do I need to tweak / configure in order for X-Windows to launch?  I noticed that xauth was already installed, however I had to install the rest of the framework as follows :  apt-get install xorg openbox How to compute $$\sqrt{(1\sqrt{(2\sqrt{(3\dots)})})}$$ &amp; $$\sqrt{(1+\sqrt{(2+\sqrt{(3+\cdots)})})}$$?  I understand that  $$\sqrt{(1\sqrt{(2\sqrt{(3\dots)})})}=(1^{1/2})(2^{1/4})(3^{1/8})\cdots$$  and  $$\sqrt{(1+\sqrt{(2+\sqrt{(3+\cdots)})})}=(1+(2+(3+(\cdots))^{1/8})^{1/4})^{1/2} $$  How to Proceed further? Zero vector of a vector space I know that every vector space needs to contain a zero vector. But all the vector spaces I've seen have the zero vector actually being zero (e.g. $\mathbf{0}=\langle0,0,\ldots,0\rangle$). Can't the "zero vector" not involve zero, as long as it acts as the additive identity? If that's the case then are there any graphical representations of a vector space that does not contain the origin? Can you use Magic Initiate to cast a spell you already know, and still learn another spell? I have a wizard PC who wants to gain the feat Magic Initiate and use free 1st level spell to use mage armour once a day. He already knows Mage armour, so:   Can he use the Feat to gain a free casting of Mage armour once each day? Should he get another 1st level spell but not get to freely cast it once a day? How can I cite a range of papers, the output is a range of numbers, instead of a list of numbers? In other words, when I type  ... some dummy text here is due to me \cite{me1, me2, me3, me4} ...   I want the output to be     ... some dummy text here is due to me [3-6] ...   instead of     ... some dummy text here is due to me [3.4.5.6] ...   (I use LaTeX, and am currently using the amsart class and whatever it includes. But I am open to other suggestions.) Escape velocity from a rotating black hole Two seasonal periods in ARIMA using R I'm currently using R to predict a time series with these instructions:  X &lt;- ts(datas, frequency=24) X.arima &lt;- Arima(X, order=c(2,1,0), seasonal=c(1,1,1)) pred &lt;- predict(X.arima, n.ahead=24) plot.ts(pred$pred)   As you can see I've data each hour, and I chose the seasonal period of 24 (one day).  I would like to improve my forecasting using an additional seasonal period in order to include the seasonal component of the week (seasonal length of 7*24=168 data)  Is there any method for this? How do you do it?  UPDATE: I've read  (your) blog page, maybe can I use the external regressors to simulate a second seasonal period?