How to pivot in SQL SERVER
SQL Server: Examples of PIVOTing String data
Can I choose to use only Shapiro-Wilk? Set a default parameter value for a JavaScript function 'find' utility does not output all files when using wildcards Running:  $find . -name *.exe   gives:  ./MakeItSo_1.2.2/MakeItSo_1.2.2/MakeItSo.exe ./MakeItSo.exe   but those are not the only exe files in the directory. For example, running  $find . -name ATLTester.exe   gives:  ./Debug/ATLDmoVexaTester.exe How to find collisions in a hash function knowing its coefficent? Say I have a simple hash function where $x$ is a sequence of integers:  $$h(x)=(a_1\cdot x_1+...+ a_n\cdot x_n) \bmod N=\sum_i a_i\cdot x_i \bmod N$$  where $a_1,a_2,a_3,...,a_n$ is the coefficient known to the attacker, size of $x$ can be anything smaller than $N$.   How to find 2 different inputs that hashes to the same value, i.e $0$?  I feel like this has something to do with linear combination / euclid algorithm but I'm not sure how to proceed. Creating Two Executable Jars Using maven-assembly-plugin Easiest way to alternate row colors in PHP/HTML? Here's a PHP example of mine. Can anyone find a shorter/easier way to do this?  &lt;? foreach($posts as $post){?&gt;     &lt;div class="&lt;?=($c++%2==1)?‘odd’:NULL?&gt;"&gt;         &lt;?=$post?&gt;     &lt;/div&gt; &lt;? }?&gt;  &lt;style&gt;     .odd{background-color:red;} &lt;/style&gt;   Examples in other languages would be fun to see as well. How to make a persistent live Ubuntu USB with more than 4GB I want to make a persistent live Ubuntu USB drive with more than 4GB of storage.   I know there is an option of installing directly on the drive but I don't want to do this as it will restrict the drive from working on different computers.   One option is to make an additional partition with extra space but if I do this how can I get newly installed software to be stored on this partition? I downloaded and installed version 0.29.2 of pokemon go on my Android phone, running lollipop. The app works fine most of the time, however, when I open the app without a WiFi connection (with mobile data on and working), it gets stuck on around 20% on the loading screen and doesn't budge.   The app works when I open it with a Wi-Fi connection and then leave Wi-Fi range or turn off Wi-Fi after it has passed the loading screen. However, the app will not pass the loading screen without WiFi. (Edit: Hotspots don't work either)  I've tried all the usual solutions - restarting, clearing cache, reinstalling, turning off and on mobile data. None of them work.  Any idea how I can start the app when I'm not in WiFi range? Is $\sum_{n=1}^\infty \frac{\sin(2n)}{1+\cos^4(n)}$ convergent? As I was just checking this 'child prodigy' out on Youtube, I stumbled upon  video, in which Glenn Beck asks the kid to do the following proof:    Further on, the kid starts sketching a proof (without a shadow of a doubt regarding the accuracy of his solution ) including the Integral Test. I don't know much about improper integrals since I just finished highschool, but this integral approach seemed, intuitively, pretty inaccurate to me since this is not a strictly decreasing function. Then I found this out from Wikipedia !   Furthermore, the blunt assessment that the series are convergent seems dubious as well..Upon a few computations of my own(mostly partial sums) , I tend to believe that the series are, in fact, divergent .  Can anyone suggest a rigurous take on this problem (easy as it may seem to some amongst you) ? CloudPagesURL() value not showing in HTML I am trying to pass the email value from a data extension to HTML. I am using the CloudPagesURL() in my email in attempt to grab the subscriber's email.  Here is my code syntax that I am attempting to use:  Email Code:  &lt;p&gt;&lt;a title="MyPage" href="%%=RedirectTo(CloudPagesURL(505,'Email Address',@EmailAddress))=%%" alias="ThisAlias" conversion="false"&gt;Click to unsubscribe page 505&lt;/a&gt;&lt;/p&gt;   CloudPage AMPScript Code:  %%[  VAR @emailAddress  SET @emailAddress = RequestParameter("emailaddr")  ]%%   Cloudpage HTML Code:  &lt;td width='155' valign='bottom'&gt;&lt;input type='text' name='Name1' value='%%=v(@emailAddress)=%%' id='Name1' /&gt;&lt;/td&gt;   Any reason as to why this doesn't work? My syntax might just be wrong or I might be using the CloudPagesURL() function incorrectly. No error message if the URL is very long I entered a URL with a very long parameter on Stack Exchange.  I have type this url    It shows a blank screen , does not shown any messages.    We need to show a “Page Not Found” message, same as what you did on other Stack Exchange pages. Orbiting a specific point - Orbiting Camera How would I create a camera that with the mouse, it allows you to orbit around a specifc position, with the camera always facing that point? I would also like it to be able to always be at a constant distance from the point, and be able to orbit around it in every direction.   Any ideas? How to fix very slow Ubuntu booting? How does "failure" work in Dungeon World? How does it move the story forward? I am having trouble understanding the specifics of failure in Dungeon World. According to the rules, a GM should "make a move" against players when they fail, and that's alright, I get that.  What I don't get is how a GM is supposed to advance the plot by doing so. Let's take an example:  Rick the Fighter is climbing a massive chain that serves to hold down the wizards tower, preventing it from drifting off. He makes the move Defy Danger, to avoid slipping of, since it's raining hard, and the chain is slippery with algae and moss. He rolls and get a score of 5, meaning he fails.  In the above situation, he fails climbing the chain, so the GM should make a move. I have a hard time seeing what move would advance the story here, since I feel that the failure would imply that he doesn't get to the tower.  Is this one of those situations, where you just skip making a roll, and just let the players climb the chain, or does anyone have any idea how to handle the move, so that the story is advanced somehow?  I just want to be able to give the players some dangers that aren't traps and monsters, and I thought that a flying wizards tower was cool. I'm having a hard time seeing how I can advance the story on a failure in this situation.    Let me elaborate on the problem. I will not say that it's wrong to make the players succeed with some "cost", even on a failed roll, it just makes true "failure" impossible. That's my beef about it. The players will eventually succeed at anything that doesn't outright kill them. I have the following functional equation. Find all continuous functions $f:(-1,1) \to \mathbb R$ such that $$ f(x+y)=\frac{f(x) + f(y)}{1 - f(x)f(y)} $$ The first obvious solution is $f(x) \equiv 0$. Another one I guessed, it is $f(x) = \pm \tan x$. I suspect, that there are no more solutions. The problem is that I don't know how to prove that.  Since we have a rational equation, I have no idea how to make any substitutions in order to get expression for $\tan x$ (as it is not a rational expression).  P.S. I can also show that it is true that (a) $f(0) = 0$ (take $x=y=0$), and (b) $f(-x) = -f(x)$ (take $y=-x$).  Update: there is a solution of this problem also here: Multiple chrome.exe processes in Task Manager I know that each new tab on Google Chrome have its own process, but I have 14 chrome.exe processes running actually as I can see it on the Task Manager, and only two tabs are opened on Google Chrome.    Could it be due to Chrome extensions? What other reason can open more chrome.exe process and how to avoid it? Updating directly from SP1 to SP3 I am considering applying the Service Pack 3 in a SQL Server 2008 with Service Pack 1; however, I was not able to find if there are any drawbacks in this process, specially regarding to Replication Services and Reporting Services.   Has someone done this kind of update? Was it smooth or did it generate many issues? How to change specific values in a List First, my apologies if this has already been asked/answered.  I wasn't able to find this question via search.  My question comes from Rudin's "Principles of Mathematical Analysis," or "Baby Rudin," Ch 1, Example 1.1 on p. 2.  In the second version of the proof, showing that sets A and B do not have greatest or lowest elements respectively, he presents a seemingly arbitrary assignment of a number $q$ that satisfies equations (3) and (4), plus other conditions needed to show that $q$ is the right number for the proof.  As an exercise, I tried to derive his choice of $q$ so that I may learn more about the problem.  If we write equations (3) as $q = p - (p^2 - 2)x$, we can write (4) as   $$ q^2 - 2 = (p^2 - 2)[1 - 2px + (p^2 - 2)x^2]. $$  Here, we need a rational $x &gt; 0$, chosen such that the expression in $[...]$ is positive.  Using the quadratic formula and the sign of $(p^2 - 2)$, it can be shown that we need   $$ x \in \left(0, \frac{1}{p + \sqrt{2}}\right) \mbox{ for } p \in A, $$  or, for $p \in B$, $x &lt; 1/\left(p + \sqrt{2}\right)$ or $x &gt; 1/\left(p - \sqrt{2}\right)$.  Notice that there are MANY solutions to these equations! The easiest to see, perhaps, is letting $x = 1/(p + n)$ for $n \geq 2$.  Notice that Rudin chooses $n = 2$ for his answer, but it checks out easily for other $n$.  The Question:  Why does Rudin choose $x = 1/(p + 2)$ specifically?  Is it just to make the expressions work out clearly algebraically?  Why doesn't he comment on his particular choice or the nature of the set of solutions that will work for the proof?  Is there a simpler derivation for the number $q$ that I am missing? Let $p, q \in \mathbb R$ be positive reals for which $p + q = 1$. How to prove that for any two natural numbers $n, m$ the following inequality is true?  $(1 - p^n)^m + (1 - q^m)^n \ge 1$  I don't have a big knowledge about solving inequalities, so I tried to use cauchy-schwarz inequality, binomial theorem and some other baisc techniques, but it lead me nowhere. I've been thinking about it for a long time and now I'm completly stuck.