I have a stored procedure that produces data for call center solution. However, is there a way to modify the sp so that each time the data is executed it is delivered in a different order? For Example Today: 1,2,3 Tomorrow: 2,1,3 the next day 3,1,2 . Is there a manipulation I can execute that will scramble the order whenever it is executed?
What is the best way to sort the results of a sql query into a random order within a stored procedure?
Square version of \cdot (small black square)? I'm looking for the symbol that's similar to \cdot in math mode, but instead of a small circle, it's a square. Like this: If I have an i.i.d. random variables $X_i$ from a uniform distribution on $[0,1]$.   How would I find scaling sequences $a_n$, $b_n$ such that $a_n(M_n − b_n)$ converges in distribution to a non-trivial limit function $G$ for  $ Y_i = X_i,$ and $M_n = \max(Y_1,...,Y_n) $ Analog voltage level conversion (level shift) I have a joystick that puts out analog voltage somewhere between 1.5V and 3.5V.  I want to transform this range of voltage to control a motor controller that takes analog voltage between 0V and 5V.  How do I level shift and amplify properly? Canonical replacing Unity with gnome-shell in Ubuntu 18.04 what now? The default desktop environment in Ubuntu 18.04 is going to be gnome-shell instead of Unity 8.  Does this mean development of Unity is stopped? or just that we can expect it to be beta a bit longer?  source on  post by Mark Shuttleworth. phoronix also posted about it  and here about the We always say that tree levels are classical but loop diagrams are quantum.  Let's talk about a concrete example： $$\mathcal{L}=\partial_a \phi\partial^a \phi-\frac{g}{4}\phi^4+\phi J$$ where $J$ is source.   The equation of motion is $$\Box \phi=-g \phi^3+J$$  Let's do perturbation, $\phi=\sum \phi_{n}$ and $\phi_n \sim \mathcal{O}(g^n) $. And define Green function $G(x)$ as $$\Box G(x) =\delta^4(x)$$  Then   Zero order:  $\Box \phi_0 = J$   $\phi_0(x)=\int d^4y G(x-y) J(y) $  This solution corresponds to the following diagram:  First order:  $\Box \phi_1 = -g \phi_0^3   $  $\phi_1(x)=-g \int d^4x_1 d^4x_2 d^4x_3 d^4x_4 G(x-x_1)G(x_1-x_2)G(x_1-x_3)G(x_1-x_4)J(x_2)J(x_3)J(x_4) $  This solution corresponds to the following diagram:  Second order:  $\Box \phi_2 = -3g \phi_0^2\phi_1  $  $\phi_2(x)= 3g^2 \int d^4x_1 d^4x_2 d^4x_3 d^4x_4 d^4x_5 d^4yd^4z  G(x-y)G(y-x_1)G(y-x_2)G(y-z)G(z-x_3)G(z-x_4)G(z-x_5) J(x_1)J(x_2)J(x_3)J(x_4)J(x_5) $ This solution corresponds to the following diagram:  Therefore, we've proved in brute force that up to 2nd order, only tree level diagram make contribution.  However in principle the first order can have the loop diagram, such as  but it really does not occur in above classical calculation.  My question is:   What's the crucial point in classical calculation, which forbids the loop diagram to occur? Because the classical calculation seems similiar with quantum calculation. How to prove the general claim rigorously that loop diagram will not occur in above classical perturbative calculation. Calculate intersection of a line with a plane I was reading something about: “Intersection of a line with a plane”. But I don’t fully understand how to calculate it on their way.  The goal is to calculate where the plane and the line will “cross”. These items are given:   The eye is in position: O(0,0,-10)   A point of a 3D-object is P(10,20,30) The screen has the equation z=0   I have a questions about how they calculate this:    This part is clear. That is the location form the eye (vector representation).   They specify the location of the plane, there is nothing strange here (vector representation).   Now they calculate what part of the line will cross, how did they calculate this? How did they know a = 1/4? And b = 10/4?  This is everything that was given. Is this a correct way for passing an environment variable in sudo ?  sudo -u www-data -b env FOOBAR="foobar" /home/user/folder/daemon Sometimes I have asked a question which got no answers, but is answered in the comments to the question.  How should I handle these questions? I can't accept an answer, so it is never an accepted question.  For example this one:   (ok here the answer in the comments is from me, but nevertheless I also have others of them) Are counters (noun) physical things? Why is it safe to use 15 A receptacles on a 20 A circuit? How to prevent US post code formats I have an issue with American and Canada postcodes in accounts and contacts. Some of the users are creating the salesforce records with postcodes like (MD 20904), when we sending post code from salesforce to SAP integration, SAP system is rejecting salesforce records as postcode is not in correct format.   My question is:   what are actual US and canada post code formats? If Users are creating the post codes with MD 20904, how would prevent through validation rule like only accept sepecific format? How to find all files with the same extension within a directory I want to search for all .conf files in /etc/. I tried grep -r *.conf /etc, but the result isn't right. What am I doing wrong? Someone recently asked me why a negative $\times$ a negative is positive, and why a negative $\times$ a positive is negative, etc.  I went ahead and gave them a proof by contradiction like so:  Assume $(-x) \cdot (-y) = -xy$  Then divide both sides by $(-x)$ and you get $(-y) = y$  Since we have a contradiction, then our first assumption must be incorrect.  I'm guessing I did something wrong here. Since the conclusion of $(-x) \cdot (-y) = (xy)$ is hard to derive from what I wrote.  Is there a better way to explain this?  Is my proof incorrect?  Also, what would be an intuitive way to explain the negation concept, if there is one? Extracting intersection areas in R I have two polygons. One contains fields(X,Y,Z) and the other contains soil types (A,B,C,D). I want to know what  area of every field contains which type of soil. I tried the following:    library(rgdal) library(rgeos) Field&lt;-readOGR("./","Field") Soil&lt;-readOGR("./","Soil") Results&lt;-gIntersects(Soil,Field,byid=TRUE) rownames(Results)&lt;-Field@data$FieldName colnames(Results)&lt;-Soil@data$SoilType  &gt; Results       A     B     C     D Z  TRUE FALSE FALSE FALSE Y FALSE  TRUE  TRUE FALSE X  TRUE  TRUE  TRUE  TRUE   and achieved good results with it telling me which field contains which soil type. However, how do I get the area instead? Finding $\tan t$ if $t=\sum\tan^{-1}(1/2t^2)$ I am solving this problem. If $$\sum\limits_{i=1}^{\infty} \tan^{-1}\biggl(\frac{1}{2i^{2}}\biggr)= t$$ then find the value of $\tan{t}$.   My solution is like the following: I can rewrite: \begin{align*} \tan^{-1}\biggl(\frac{1}{2i^{2}}\biggr) &amp; = \tan^{-1}\biggl[\frac{(2i+1) - (2i-1)}{1+(2i+1)\cdot (2i-1)}\biggr] \\\ &amp;= \tan^{-1}(2i+1) - \tan^{-1}(2i-1) \end{align*}  and when I take the summation the only term which remains is $-\tan^{-1}(1)$, from which I get the value of $\tan{t}$ as $-1$. But the answer appears to be $1$. Can anyone help me on this. How does USB device recognition work? I'm curious how USB device recognition works in Windows. I imagine it's something like this:   When you plug in a device, it tells Windows "here's my device ID to tell you what I am" Windows looks to see if any drivers have been installed that match that device ID. The driver probably tells Windows what the device should be called - like "BlackBerry Curve" or "Canon Printer" If so, it somehow associates that device with that driver Otherwise, it looks for a matching driver online (if you let it)   Am I right? If so, that still leaves some questions.   When you install drivers, where do they go? Are they files in a folder, or do they get added to the registry? What is Windows doing when it first recognizes the device, thinks, and finally says "your new device is installed and ready to use?" Where does Windows look for missing drivers? Is it in their own database? Do device manufacturers submit drivers to Microsoft for inclusion there?   Can anybody explain how this process really works? Also, do other OSes do this differently? "This site is all about getting answers. It's not a discussion forum. There's no chit-chat." The  has this text:     This site is all about getting answers. It's not a discussion forum. There's no chit-chat.   It's probably an oversight and copied from the regular site tours. Can it be reworded/removed?  Right above that text, there's this:      So each community has a meta to discuss site-specific issues, and Meta Stack Exchange is for conversations about problems and ideas that affect the whole network.   Don't they contradict eachother? How do I pull from a Git repository through an HTTP proxy? Note: while the use-case described is about using submodules within a project, the same applies to a normal git clone of a repository over HTTP.  I have a project under Git control.  I'd like to add a submodule:  git submodule add http://github.com/jscruggs/metric_fu.git vendor/plugins/metric_fu   But I get  ... got 1b0313f016d98e556396c91d08127c59722762d0 got 4c42d44a9221209293e5f3eb7e662a1571b09421 got b0d6414e3ca5c2fb4b95b7712c7edbf7d2becac7 error: Unable to find abc07fcf79aebed56497e3894c6c3c06046f913a under http://github.com/jscruggs/metri... Cannot obtain needed commit abc07fcf79aebed56497e3894c6c3c06046f913a while processing commit ee576543b3a0820cc966cc10cc41e6ffb3415658. fatal: Fetch failed. Clone of 'http://github.com/jscruggs/metric_fu.git' into submodule path 'vendor/plugins/metric_fu'   I have my HTTP_PROXY set up:  c:\project&gt; echo %HTTP_PROXY% http://proxy.mycompany:80   I even have a global Git setting for the http proxy:  c:\project&gt; git config --get http.proxy http://proxy.mycompany:80   Has anybody gotten HTTP fetches to consistently work through a proxy?  What's really strange is that a few project on GitHub work fine ( for example), but others consistently fail ( for example). Need to develop a tapered spacer for under a car lift on an angled concrete slab I need to fabricate/develop an angled spacer.  13 inch wide by 10 inch long, by 3/4 inch to 1 3/8 inch thick. This spacer is needed to go under two of the posts of a hobbyist car lift in my garage. The garage floor is angled by the door where two of the four corner posts will go. These two rear posts need to be on a flat surface and at the same level as the two front posts.  Each post pad will need to handle approximately 2000 pounds. I was thinking of building a 4-sided mold where the column pads would be on the angled concrete and pouring some type of epoxy, resin, or cement into the mold. Which the metal plate from car lift posts would sit on. enter image description here How can I output a list of all installed packages with installation date and additional information?