Transpose Microsoft SQL Server table
Simple way to transpose columns and rows in SQL?
Something's been bugging me about SO for a while now, that is the inaccuracy of "length of time" strings.  The best example I can give at the moment is .  If you look at the length of time he's been registered, it says 1 year.  He joined the site September 2008, which is only 3 months off two years.  It's the same with answers - you can give an answer 50 seconds before anyone else, but at certain times page views will show both as "5 minutes ago" or whatever.  That's not quite as bad, but with answers being sorted "randomly by votes" by default you could lose out on votes or being marked as the correct answer to the slower answer even if they're both the same.  There's probably a better method amongst these, IMO:   "Vulgar fraction" unicode characters     Member for 1½ years   answered 5¼ minutes ago asked 3⅓ hours ago  Different units   Member for 21 months (at least it's better than "1 year") Answered 306 seconds ago (ugly, I know) Asked 64 minutes ago (also ugly)  Combining units   Member for 1 year 9 months (fits easily on the profile screen) Answered 5 minutes 6 seconds ago (probably too long) Asked 3 hours 20 minutes ago (also long)  Rounding up   I personally prefer option 1, unicode fraction characters.  "Member for 21 months" is pretty good too because it's easy to quickly work out.  "Asked 452 seconds" ago is horrible though.  EDIT: I'm completely aware of the timestamp hover because I am forced into using it so much. It's a great feature, but it's not really in your face so not everyone knows about it. I still think there's a better "glancing" solution than having to hover over the time string. What if MSE used a different rep model for privileges? How can I have a different input method for each app window on windows 8. When I change input language to ENG all app window also uses this method and I don't want that. Like windows 7 that has a different input method for this purpose. thanks I'm from Central Pennsylvania, and apparently, we have a strange language construct in this area. I was recently talking about how "my car needs washed" to a friend from NJ, and she told me that my sentence was grammatically incorrect.   I realize she's right, and I realize my options are "my car needs to be washed" or "my car needs washing". But I'm not clear on the precise rule being invoked. I have absolutely no experience with Linux, and I desperately need to get my computer back up and running again with Windows.  How do I remove Ubuntu and reinstall Windows?    Editor's note: many of the answers are about removing Ubuntu from dual-boot but keeping Windows (which is a bit complicated), while other answers are about removing Ubuntu from single-boot (which is easy: basically just format the disk while installing Windows). The question as written is ambiguous between dual-boot or single-boot. Existence of a Riemannian metric inducing a given distance. Let $M$ be a smooth, finite-dimensional manifold. Suppose $M$ is also a metric space, with a given distance function $d: M \times M \rightarrow \mathbb{R}_{+}$, which is compatible with the original (manifold) topology on $M$.  Question: is there a Riemannian metric $g$ on $M$ such that the distance $$d_g(p, q) = \inf_{\gamma \in \Omega(p, q)} L_g(\gamma)$$ coincides with $d$?  I believe that this setting is very standard, but for the sake of completeness: $L_g$ denotes the Riemannian length of the curve $\gamma$, and $\Omega(p, q)$ the set of all piecewise smooth curves $\gamma : [a, b] \rightarrow M$ s.t. $\gamma(a) = p$ and $\gamma(b) = q$. Thanks in advance. Version tags reloaded I'm getting sick of version numbers in tag names (aka version tags). Look,      I just want them all to be just . They are all about JSF. I browse and answer questions about JSF. I don't want to browse in all those different tags. I don't want gold badges for both  and . I can't hammer a duplicate  question because I don't have a gold badge for that. Across years I observed that a version tag is usually only picked by the asker when a &quot;relatively new&quot; or &quot;relatively old&quot; version is being treated in the question. When the &quot;currently mainstream&quot; version is being treated,  or when the asker is &quot;more proficient&quot; in the language, then askers often just pick the versionless . While moving in time, this may cause confusion by future readers when the version isn't explicitly specified anywhere in the question. I try to maintain them by adding/removing the version tag depending on its relevance, and by adding the versionless tag when it's absent. It only feels a neverending story. I'm sure other tag caretakers also have mixed feelings on this. I propose to normalize the version from the tag name:  Ban version numbers in tag names in the model (not in the UI). Add an optional single-choice version field to the Tag entity in the model. Users with edit privileges (no suggested edits please) must be able to change versions. Users with gold tagbadges must be able to add and edit versions. I'd imagine the version edit thing to be reachable via that tag info popover (when you hover the tag). Tags themselves however should look exactly the same, the version just separated with e.g. a hyphen from the tag name.  When in place, migration of existing version tags should be piece of cake. There's apparently already a script in place which recognizes version tags, it could be reused to re-match current tags and extract the version from it into the new version field. The alternative would be to automatically add the versionless tag when a version tag is being used. But this is IMO only tag pollution.  I'm posting this on meta.se instead of meta.so because version numbers aren't only on SO a problem, but on basically all HW/SW related sites. Other explanation for cosmological redshift? I have critical low storage level and can't understand what takes much of it and how that's possible that the installed applications can use 7 GB? I only use a few social media clients without any games or soft like Photoshop. Also on the second screenshot it indicates that the apps are using just 1.13 GB and so I can't understand the situation. Also what is the "Other"? Why is it that a sequence in a closed, bounded interval [a, b] is a bounded sequence? What is the formal proof of this proposition from the definition of a bounded sequence? What does "sudo apt-get update" do? I am wondering what sudo apt-get update does?  What does it update? Are there uncountably many surjections from $\mathbb N$ to $\mathbb N$? Statement: There are uncountably many surjections from $\mathbb N$ to $\mathbb N$.  Is the following proof valid:  The real numbers are uncountable.   There exists a bijection between the set of real numbers and the set of all functions from $\mathbb N$ to $\{0,1\}$.   Given a function, $f$, from $\mathbb N$ to $\{0,1\}$, construct a surjection from $\mathbb N$ to $\mathbb N$, denoted $g$, as follows:  We map the $n$th composite number to $n$, and the nth prime, to $f(n)$.   Clearly this is a surjection since the composite numbers are countable. Clearly different functions $f$ lead to different surjections $g$. Since there are uncountably many $f$s, there are uncountably many surjections $g$. Electric monopoles do exist, but why cannot magnetic monopoles exist?    The question is closed because I need to clarify it, but I don't know how I could ask it another way. However, I've recieved many answers that were appropiate and added something to my knowledge, so I consider it answered. All of a sudden, without any change in the index.html, our site is showing up in Google search results (on multiple browsers and devices) with Google Preview text that, instead of giving a summary of our site, now says:     Your browser does not currently recognize any of the video formats available. Click here to visit our frequently asked questions about HTML5 video.     We have a YouTube embed on our homepage that does include an html5 parameter in the media URL link in the embed, but there are no issues playing the video with any browser and device we can find.  What would suddenly cause this text to appear in Google search results?   We are using the  tags as the metatags in the &lt;head&gt; of our webpage and do indeed have title and description tags.    To mimic the behavior of Googlebot, I installed Windows on a VM and got Chromium 41 running. I get the same Google Preview text with the html5 video message when the site comes up in Google search results using this browser.    When I view the site in Chromium 41, I see the YouTube embed and it renders on the page and plays with no issue, just as with all other browser and devices we've tested on. The only time we see this message is in the Google search results, not on our actual site. How do I find a point a given distance from another point along a line? Correlation coefficient between a (non-dichotomous) nominal variable and a numeric (interval) or an ordinal variable I've already read all the pages in this site trying to find the answer to my problem but no one seems to be the right one form me...  First I explain you the kind of data I'm working with...  Let's say that I have an array vector with several names of city, one for each of 300 users. I also have another array vector with scores response to a survey of each user or a continuous value for each user.  I would like to know if exist a correlation coefficient that compute the correlation between these two variables so, between a nominal and a numeric/continuous or ordinal variables.  I've searched on the Internet and in some pages they suggest to use the contingency coefficient or Cramer's V or Lambda coefficient or Eta . For each of this measure the just say that they could be applied for such data in which we have a nominal variable and interval or numerical variable. The thing is that searching and searching, trying to understand every one of them, sometime is written or watching the examples that they are reasonable to use them if you have dichotomous nominal variable, except for Cramer's V, other time is not written any requirement for the type of data. A lot of other pages say that is right to apply regression instead, that is right, but I would just simply like to know if there is a coefficient like pearson/spearman for this kind of data.  I also think that is no so properly to use Spearman Correlation coeff since the cities are not sortable.  I have also built the function of Cramer'sV and Eta by myself (I'm working with Matlab) but for Eta they don't talk about any p-value to see if the coefficient is statistically significant...  In the matlabWorks site there is also a nice toolbox that says to compute eta^2 but the kind of input it needs is not understandable.  Is here someone that have done a test like mine? If you need more detail to understand the kind of data I'm using just ask me and I'll try to explain you better. What's the difference between the server version and the desktop version? Leagues still count association bonus Let $m$ be the largest real root of the equation $\frac3{x-3} + \frac5{x-5}+\frac{17}{x-17}+\frac{19}{x-19} =x^2 - 11x -4$ find $m$ Let $m$ be the largest real root of the equation $$\frac3{x-3} + \frac5{x-5}+\frac{17}{x-17}+\frac{19}{x-19} =x^2 - 11x -4.$$ Find $m$.   do we literally add all the fractions or do we do something else  I have no clue how to solve this Suppose you cut a five year old's hair, save it for 10 years, and then use it for a Polyjuice transformation. What age do you turn into: The toddler or the teenager?