How to do sum of col results from a SQL Stored Procedure
Insert results of a stored procedure into a temporary table
Sometimes a tag wiki excerpt or body ends up with unacceptable or useless content: plagiarized text that must be removed, or a totally unhelpful dictionary definition. (For example:  — and I've seen this situation many times before.)  The only way to get rid of that content is to submit replacement text that meets the minimum length requirement. This is not always easy as writing a decent wiki, and especially a decent excerpt, requires subject knowledge.  Currently the users or even moderators who are alerted to unacceptable content in a tag wiki cannot remove that content without providing their own, which they are not always in a position to do. Yet these wikis would be better off with no content than with either unacceptable or unhelpful content, or some content written by a non-expert in a hurry.  Please provide a way for users to blank a tag wiki excerpt or body. I'm not sure what the reputation requirement should be: same mechanism as for tag wiki edits (suggested edits with approval), or only done directly by a user with the trusted user (20k) privilege, or moderator-only. What is the best way to deal with very complex forms? I'm trying to give the best experience to users of a very huge system (like a CRM). It has a lot of forms and much of these have a lot of fields. My doubt is about if I should use a single column form (which raises too much vertical scrolling), or a two columns form (which needs less vertical scrolling and uses more horizontal white space) and a last one with four columns (which has few scrolling and uses almost whole white space to try to keep most of the fields above the fold).  It's important to say that our clients hate scrolling, and they always ask why we don't use the horizontal white space when we present a one column form).  So I'm little bit confused about it, because a lot of UX studies and good practices recommend to do not use/avoid multicolumn forms but the clients most of times ask multi column forms.  Our clients are very used to desktop programs and not everybody is very familiar with web based systems.  Below follows some possibilities I would like to share to illustrate an example of a complex form in the system with the three possibilities I mentioned:    In the example above I'm using the one column form (most recommended in UX studies), but with a very long vertical scroll.    In the second example I tried to reduce vertical space by using two columns.    This is the client's favorite one, 4 columns using white space and trying to keep everything above the fold.   The lengths of fields are based on the average of characters amount for each field.   I would like to know your opinion about the best approach to this case. Say that we have a secure random number generation that outputs 32 bit random numbers, so it's output is a true random number between 0 and a MAX.  What is the best way to map this random number to a defined range (say I want something random between X and Y) without loosing too much entropy? Could a Homorphus Charm Change a Werewolf Back Into a Human Before the Moon Cycle Ends? ‘Nice loud howl, Harry – exactly – and then, if you’ll believe it, I pounced – like this – slammed [the werewolf] to the floor – thus – with one hand, I managed to hold him down – with my other, I put my wand to his throat – I then screwed up my remaining strength and performed the immensely complex Homorphus Charm – he let out a piteous moan – go on, Harry – higher than that – good – the fur vanished – the fangs shrank – and he turned back into a man. Simple, yet effective – and another village will remember me forever as the hero who delivered them from the monthly terror of werewolf attacks.’   Gilderoy Lockhart - Chamber of Secrets - chapter 10 - The Rogue Bludger   Yeah, yeah. I know: consider the source! We all know Gilderoy Lockhart is a fake and a fraud in that he took credit for other heroic wizards' work. However, it occurred to me that in order to sell his books, he would have had to have written accurate and real spells and charms and potions, etc, into the books, or else everyone would have known right away that he was a turkey.   So is it possible there's an actual Homorphus Charm that will change a werewolf back into a human before the werewolf's moon cycle is over? If so, why on earth would they not have used it on Remus Lupin (for Lupin's safety) or Fenrir Greyback (for the community's safety)? How do you test non-live sites before switching DNS? I have a few websites that I need to move to a new server - how would I test that they work before switching DNS? What URL would I navigate to? What are the guidelines for using version-specific tags? I believe that some of my questions were asked before but I didn't find any satisfying guidance. I just found only . I hope senior members will help me to understand the situation and use tags correctly.  I have several questions which are related to following explanation:   What is current community's attitude towards version specific tags on Stack Exchange?  How to correctly use version specific tags?  When is it good to create version specific tag? Should any version specific tags be at least marked as synonyms to version unspecific tags? Should I use version specific tags if I re-tagging questions?  Should I re-tag questions if I think that incorrect version specific tag is used?   For example, I mainly visiting questions related to two main topics: WCF and Entity framework. Tagging questions in these topics follow very different rules. WCF uses single main tag  sometimes combined with  currently proposed as synonym to WCF, whereas Entity framework currently have:      - version 2 and 3 never existed  - I started this tag myself but now I think it was a mistake   and two ridiculous tags (both for CTP5 of EF 4.1 – their meaningful lifetime was about 3 months):         I've already several times retagged questions introducing tag for EF 4.1 RC. Separate problem is in Code-first approach related strictly to  where 5 other tags are used to describe the same:           I asked for merging these tags in .  As you can see that EF topic currently contains too many tags to describe the same. There are other related tags to EF but they are mainly used as supporting tags for specific features.  First I thought this is a common situation because ASP.NET MVC uses also new tag for each version even questions usually asks for general problems related to any version but then I was informed by @Richard in  that EF is probably tag polluted.  I regularly retag questions in EF topic. Currently I'm using:     as general topic's tag because I was already informed by @Slauma  that people usually have only this tag between their favorites and I should not remove it. It was a good point.   for questions related directly to EFv4 features  for questions related directly to EF 4.1 features  for questions related to fluent and annotations mapping from EF 4.1   But still I think that  and  are somehow redundant but I'm not sure if my opinion is shared by other participants in these tags. WCF also has 3 versions and almost twice as more questions than EF and it still uses only single main tag  without any problem. I think the used version should be information included in a question.  Are there any general rules? What about version related tags to C#, .NET and ASP.NET MVC? I first thought that it is common and accepted approach to create version specific tags just because users around ASP.NET MVC (strong tag) do the same.  Sometimes I think I received privileges too early and I don't use them correctly. I need some guidance. I just went to install Java 8 on my ancient laptop that runs Windows XP SP3.  Java pops up a message:     Java 8 requires a newer version of Windows. You may continue with the installation, but for Java to work as specified we recommend upgrading your computer's operating system.   Will Java fail to work properly on Windows XP? Or is this just Oracle trying to be secure? How do I set a Boolean field with "yes" and "no" values? Are quotes needed for local variable assignment? Can I safely omit quotes on the right side of a local assignment?  function foo {     local myvar=${bar}     stuff() }   I'm mainly interested in bash, but any info on corner cases in other shells are welcome. How to find perpendicular vector to another vector? How do I find a vector perpendicular to a vector like this: $$3\mathbf{i}+4\mathbf{j}-2\mathbf{k}?$$ Could anyone explain this to me, please?  I have a solution to this when I have $3\mathbf{i}+4\mathbf{j}$, but could not solve if I have $3$ components...  When I googled, I saw the direct solution but did not find a process or method to follow. Kindly let me know the way to do it. Thanks. There is a 2d rotation matrix around point $(0, 0)$ with angle $\theta$.  $$ \left[ \begin{array}{ccc} \cos(\theta) &amp; -\sin(\theta) \\ \sin(\theta) &amp; \cos(\theta) \end{array} \right] $$  Next, there is a 3d rotation matrix around point $(0, 0, 0)$ and unit axis $(u_x, u_y, u_z)$ with angle $\theta$ ().  \begin{bmatrix} \cos \theta +u_x^2 \left(1-\cos \theta\right) &amp; u_x u_y \left(1-\cos \theta\right) - u_z \sin \theta &amp; u_x u_z \left(1-\cos \theta\right) + u_y \sin \theta \\ u_y u_x \left(1-\cos \theta\right) + u_z \sin \theta &amp; \cos \theta + u_y^2\left(1-\cos \theta\right) &amp; u_y u_z \left(1-\cos \theta\right) - u_x \sin \theta \\ u_z u_x \left(1-\cos \theta\right) - u_y \sin \theta &amp; u_z u_y \left(1-\cos \theta\right) + u_x \sin \theta &amp; \cos \theta + u_z^2\left(1-\cos \theta\right)  \end{bmatrix}  How it is possible to generalize rotation matrix on $N$ dimension around zero point and $N-2$ dimensional unit axis with angle $\theta$? More Efficient Spatial join in Python without QGIS, ArcGIS, PostGIS, etc I'm attempting to do a spatial join much like the example here: . However, that approach seems really inefficient / slow. Even running this with a modest 250 points takes almost 2 minutes and it fails entirely on shapefiles with > 1,000 points. Is there a better approach? I'd like to do this entirely in Python without using ArcGIS, QGIS, etc.  I'd also be interested to know if it's possible to SUM attributes (i.e. population) of all the points that fall within a polygon and join that quantity to the polygon shapefile.       Here is the code I'm trying to convert. I get an error on line 9:  poly['properties']['score'] += point['properties']['score']   which says:     TypeError: unsupported operand type(s) for +=: 'NoneType' and 'float'.    If I replace the "+=" with "=" it runs fine but that doesn't sum the fields. I've also tried making these as integers but that fails as well.  with fiona.open(poly_shp, 'r') as n:    with fiona.open(point_shp,'r') as s:     outSchema = {'geometry': 'Polygon','properties':{'region':'str','score':'float'}}     with fiona.open (out_shp, 'w', 'ESRI Shapefile', outSchema, crs) as output:         for point in s:             for poly in n:                 if shape(point['geometry']).within(shape(poly['geometry'])):                       poly['properties']['score']) += point['properties']['score'])                     output.write({                         'properties':{                             'region':poly['properties']['NAME'],                             'score':poly['properties']['score']},                         'geometry':poly['geometry']}) finite and infinite product of discrete space I would like to install Ubuntu alongside Windows 7 on a HP G62 Notebook. Although I have installed  Ubuntu in a dual-boot many times before, I found out that this model has already four partitions.    Partitions:   SYSTEM (NTFS, 199MB, used 66.59MB) Partition without any tag: NTFS (579GM, used 129GB)  RECOVERY (NTFS 16.74 GB, used 2.42GB)  HP_TOOLS (FAT32, 103.34 MB, used 13.23MB)   Since I am not an expert with partitions I would like to get advice on how to do this.  My first idea is this one:   Free some space from /dev/sda2 (I don't know if could also free some other space) delete the HP_Tools partition (I have already created a backup) create an extended partition with the free space in #1 containing three parititions: swap (1gb); / (EXT4, 30GB);  /home (EXT4, 120GB)   Another option is to use wubi instead.  What do you think? Is there any other way to achieve this?  PS: I really think this HP policy of using 4 partitions is not a coincidence  PS: I tried using gparted from the live CD and I got a warning message saying that if I freed some space from /dev/sda2 I could create serious issues in the system Series about proxy space battles via implanted computers in kids The premise of the story is that there are 2-3 main coalitions on Earth and they fight over resources in the edges of the solar system with spaceships that are controlled from Earth by kids with computers in their heads.  If I recall correctly:   The main character's name is Tom, he starts out by conning people at some sort of gambling arcade before he is found and recruited by the "army" The Pentagon in the US has a super tall tower built in the courtyard called The Spire where most of the three books take place. The reason they need kids for this has something to do with brain elasticity and putting computers in adults causes them to go mad. All the cadets are super dismissive about learning how to program their computer aside from one girl who is super good at it. The best fighters from each side of this conflict were something of superstars, but everyone else was kept completely anonymous for their protection. There were at least 3 books last I knew, released circa 2011-2014 The third book ends with Tom being the first astronaut to Mars. The first book had a green cover, the second was yellow, and the third was red. Though I might have the order wrong. Why getting this error tlmgr Unknown directive? I haven't used tlmgr for a while but when I tried to install any package with it today, It returned following message:     (running on Debian, switching to user mode!) Unknown directive ...containerchecksum c59200574a316416a23695c258edf3a32531fbda43ccdc09360ee105c3f07f9fb77df17c4ba4c2ea4f3a5ea6667e064b51e3d8c2fe6c984ba3e71b4e32716955... , please fix it! at /usr/share/texlive/tlpkg/TeXLive/TLPOBJ.pm line 210,  line 5579.   I've tried to use fix specified on :     You have to download update-tlmgr-latest.sh from the tlpretest repository   and run it. Afterwards you will be able to work with tlmgr as usual   (announced by Norbert a few hours ago).   I've downloaded it from , but it returned another error:  Verifying archive integrity... All good. Uncompressing TeX Live Manager Updater............................................................................................................................................................................ ./runme.sh: Cannot find TeX Live root using kpsewhich --var-value=SELFAUTOPARENT. ./runme.sh: Please set your PATH as needed, otherwise it's hopeless.   Minimum example  Install cleanly vanilla TeXLive 2016 with tmlgr after having old TeXLive in the system successfully: there is no errors/warnings in /usr/local/texlive/2016/*.log, complete log example . Run the following but you get the same output as above when trying to update the system  root@masi:/home/masi/Downloads/t/install-tl-20161019# tlmgr update --self (running on Debian, switching to user mode!) Unknown directive ...containerchecksum c59200574a316416a23695c258edf3a32531fbda43ccdc09360ee105c3f07f9fb77df17c4ba4c2ea4f3a5ea6667e064b51e3d8c2fe6c984ba3e71b4e32716955... , please fix it! at /usr/share/texlive/tlpkg/TeXLive/TLPOBJ.pm line 210, &lt;$retfh&gt; line 5579. I have a c++ header file containing a class. I want to use this class in several projects, bu I don't want to create a separate library for it, so I'm putting both methods declarations and definitions in the header file:     // example.h #ifndef EXAMPLE_H_ #define EXAMPLE_H_ namespace test_ns{  class TestClass{ public:     void testMethod(); };  void TestClass::testMethod(){     // some code here... }  } // end namespace test_ns #endif   If inside the same project I include this header from more than one cpp file, I get an error saying "multiple definition of test_ns::TestClass::testMethod()", while if I put the method definition inside the class body this does not happen:  // example.h #ifndef EXAMPLE_H_ #define EXAMPLE_H_ namespace test_ns{  class TestClass{ public:     void testMethod(){         // some code here...     } };  } // end namespace test_ns #endif   Since the class is defined inside a namespace, shouldn't the two forms be equivalent? Why is the method considered to be defined twice in the first case? Center image element in parent div Will $\sum^{\infty}_{n=1}|a_n|^p$ converge? Given that $\sum^{\infty}_{n=1} a_n^2$ converges,then, will $$\sum^{\infty}_{n=1}|a_n|^p$$ converge for $p&gt;2$?  I couldn't find a counterexample neither a proof but it looks to me that this is true. For $p=3/2$, I found the counter example $\sum a_n=\displaystyle \sum^{\infty}_{n=1} \frac{1}{n^{2/3}}$ Which PHP function can return the current date/time?