CTE with insert and update in sql server 2008
How can I reuse a Common Table Expression
How to check if a row exists in MySQL? (i.e. check if an email exists in MySQL) What do you call a person who does/thinks the opposite of the crowd for just that reason? Such a person does not hold in high regard the decisions taken by a group (not a team) of people. She believes that groups tend to be anarchic and don't serve their purpose.  An example would be - for outings with friends, this person will not like planning it with the group since they will mess it up.  Therefore, this person has convinced herself that when more people are involved with something, it will be worse. She distrusts crowds instinctively basically. Is there a standard pronunciation for gender-neutral -@ or -x More and more I see, especially in activist communities, Spanish-derived words ending in x or @ in order to neuter the gendering inherent in the original language. For example: latinx (or latin@) as opposed to latina and latino. How, though, are these endings pronounced? Please provide evidence of how this orthography is most commonly pronounced. Note 1: I recognize this is in an English Language site, rather than a Spanish language site, but this phenomenon is very much happening in English, albeit with Spanish loan words. Therefore the question is relevant to non-Spanish-speaking English speakers. Note 2: A question like this can lead to politically charged or, at least, sarcastic comments. Please refrain from bringing in your biases for or against. Note 3: This question is not seeking opinions as to how some people pronounce the suffixes. Answers should address evidence of a developing orthodoxy in pronunciation. Smeared creamy look effect i came across a photo where the gradient looks like it s smeared from cream. It is hard to explained by saying so here is the  Let say i create 2 similar shapes with the gradient pattern then adjust the opacity but the edges will still remain. But in the example the edges are appeared to be soft and hard randomly. Thanks in advance ! Inserting an image in plain TeX I used the OzTeX implementation of TeX, also I used to typeset my docs in plain TeX, not LaTeX for me, so I had no problem to insert an image using the OzTeX, now I'm back to TeX docs, am using the TeXWorks frontend, but I can't insert an .eps image file, it seems the \includegraphics macro its only for LaTeX, so I can't use it, any idea on how to insert an image when using plain TeX? I've installed phpmyadmin sudo apt-get install phpmyadmin. Of course, I have also mysql and a web server running properly.  Now how can I reach it? This came up in  , but I can't see good documentation or examples that explain how the feature works. Is $\cot(z)-\frac1z$ bounded on a given circle? How can I develop for iPhone using a Windows development machine? Is there any way to tinker with the iPhone SDK on a Windows machine? Are there plans for an iPhone SDK version for Windows?  The only other way I can think of doing this is to run a Mac VM image on a VMWare server running on Windows, although I'm not too sure how legal this is. What is the maximum number of Locations Discovered that one can achieve in Skyrim? Do I leave a revised question closed even though it falls out of scope for a different reason than the original closure reason? I have 4 copies of the Hot Questions widgets.  Sometimes, possibly after they reload on their own, I can only tap to open the last widget I added. If I tap on the question of any others nothing happens.  If I refresh each one then tapping works on the one I refreshed. How to count the node a user has created in a View? I wanted a list of sub-domains of Stack Exchange that are not mentioned over here   Some of the sub-domains I found which were not mentioned are       Are there any other which are not mentioned?    Mentions by , ,             Other mentions below which are not mentioned in "All Sites" but are mentioned in the drop down menu on the top left of the Stack Exchange website         Any other website that's left out ? What is a mixin, and why are they useful? Is there a way to make an Oracle query behave like it contains a MySQL limit clause? In MySQL, I can do this: select *  from sometable order by name limit 20,10  to get the 21st to the 30th rows (skip the first 20, give the next 10). The rows are selected after the order by, so it really starts on the 20th name alphabetically. In Oracle, the only thing people mention is the rownum pseudo-column, but it is evaluated before order by, which means this: select *  from sometable where rownum &lt;= 10 order by name  will return a random set of ten rows ordered by name, which is not usually what I want. It also doesn't allow for specifying an offset. I currently only have remote access to this CentOS box, I need to move /var form the primary RAID to a new set of disks that was installed with more space, My current thoughts on how to accomplish this is to temporarily mount the new RAID to /tmp/var. rsync everything from /var to /temp/var then modify the fstab to point /var at the new disks.  Here is my question. how do I delete the existing /var on the primary disks once I have the new disks mounted to that location (assuming this is even possible remotely)? Drawing users' attention to unrecoverable actions? Name of a special matrix I have a matrix which is kind of symmetrical with the other diagonal, i.e., something like  $$A = \left[ \begin{array}{c c c c}    a &amp; b &amp; c &amp; d \\    e &amp; f &amp; g &amp; c \\    h &amp; i &amp; f &amp; b \\    j &amp; h &amp; e &amp; a  \end{array} \right]$$  Does this matrix have a special name in literature? What are it's properties?  And a matrix that is symmetrical by both diagonals   $$A = \left[ \begin{array}{c c c c}    a &amp; b &amp; c &amp; d \\    b &amp; e &amp; f &amp; c \\    c &amp; f &amp; e &amp; b \\    d &amp; c &amp; b &amp; a  \end{array} \right]$$  What's the name of it? Any interesting properties? I am a graduate student in economics who recently converted to R from other very well-known statistical packages (I was using SPSS mainly). My little problem at the moment is that I am the only R user in my class. My classmates use Stata and Gauss and one of my professors even said that R is perfect for engineering, but not for economics. He said that many packages are built by people who know a lot about programming, but not much about economics and therefore are not reliable. He also mentioned the fact that since no money is actually involved in building an R package, there is therefore no incentive to do it correctly (unlike in Stata for example) and that he used R for a time and got some "ridiculous" results in his attempts to estimate some stuff. Moreover, he complained about he random number generator in R which he said was "messy".  I've been using R for just a little more than a month and I must say I have fallen in love with it. All this stuff I am hearing from my professor is just discouraging me.  So my question is: "Is R reliable for the field of economics?".