SQLCE Subquery for smart device application
Subquery in SQL Server Compact Edition
Is the Macbook 12 inch's USB-C charger interchangeable with other USB-C chargers or devices? If there is only the Macbook 12 inch USB-C charger nearby, can it be used to charge other USB-C devices, such as any Android phones that also use USB-C? (will it be "too powerful" and damage other devices?)  Vice versa, if there is a Quick Charge 2.0 or 3.0 USB-C charger from other devices nearby, can it be used to charge the Macbook 12 inch?  The main concern is about whether it could damage the device or battery. A set with n elements has 2^n subsets I don't understand why a set with n elements has 2^n subsets. How is this calculated? I realize that {123} has empty set - 1-2-3-1,2-1,3-2,3-1,2,3 but how is the formula derived? Why am I asked for a credit card number to download a free app? I  want to download free app in my iPod touch device and i have the following doubts.  Kindly resolve me doubts.   when i try to download it asks my credit card security number. since i am trying to download free app , why do i need to provide my credit card security code? Will i be debited for downloading the free app from app store?   I cant able to find any information regarding this on apple.  Please provide me some references about this from apple and please resolve my doubts.  Thanks a lot. How to unlock Sweet Tooth in Rocket League? How do you get Sweeth Tooth's ice cream van (from Twisted Metal) in Rocket League? tabular input by columns (i.e. transpose a table) I would like to be able to transpose a tabular(x) table like in the following example. It is not necessary to be completely automated, but I don't want to change the data order, which is a painful and stupid. By "not completely automated" I mean that e.g. the headers can be done seperately etc.  Let's see the MWE:  \documentclass{article}  \usepackage{booktabs} \def\Midrule{\midrule[\heavyrulewidth]}  \begin{document}  \centering  \begin{tabular}{*6c}\toprule \bfseries Name &amp; Alice &amp; Bob &amp; Chuck &amp; Dave &amp; Eve\\\Midrule \bfseries Sex &amp; Female &amp; Male &amp; Male &amp; Male &amp; Female\\\midrule \bfseries Age &amp; 18 &amp; 19 &amp; 20 &amp; 21 &amp; 22\\\bottomrule \end{tabular}  \bigskip  Which I want to look like  \bigskip  \begin{tabular}{*3c}\toprule \bfseries Name &amp; \bfseries Sex &amp; \bfseries Age\\\Midrule Alice &amp; Female &amp; 18\\\midrule Bob &amp; Male &amp; 19\\\midrule Chuck &amp; Male &amp; 20\\\midrule Dave &amp; Male &amp; 21\\\midrule Eve &amp; Female &amp; 22\\\bottomrule \end{tabular}   \end{document}     Note: I know that , but I would like to get it without expl3 (mostly because people would might use my code quite often have an old LaTeX installed and I cannot be convincing them to change this). How to "unpivot" or "reverse pivot" in Excel? I have data that looks like this:  Id | Loc1 | Loc2 | Loc3 | Loc4 ---+------+------+------+----- 1  | NY   | CA   | TX   | IL 2  | WA   | OR   | NH   | RI   And I want to convert it to this:  Id | LocNum | Loc ---+--------+---- 1  |   1    | NY 1  |   2    | CA 1  |   3    | TX 1  |   4    | IL 2  |   1    | WA 2  |   2    | OR 2  |   3    | NH 2  |   4    | RI   What's the easiest way to do this in Excel 2007? What is the max variance distribution with fixed mean and support Is there a upper bound on the variance for a distribution that is confined say, in $[0,1]$, and has fixed mean $\mu \in [0, 1]$ Blogs link from the not existing community page refers to 404 The “blogs” link from the , e.g:        refers to another not existing page:        Looks like blogs link should refer to the same page as for “blog” link in the footer: Rejecting a PhD offer after having accepted it. Advice? How do I deploy an OpenStack cloud with Juju? I'd like to get a test cloud up and running in preparation for a possible deployment of 12.04. I messed with the UEC a bit, but have had a much harder time finding anything helpful as a primer for the new stack. There is generic documentation on Diablo, but there are likely to be a lot of pieces already handy in Ubuntu that a specific guide could save time with.  Also, as much as I would love to, my budget doesn't include the $4-6k to get a small cluster running with the Canonical support. I have a friend who is playing with me on a server we've created. Unfortunately, he is on a  Mac whereas I am on a Windows machine. I told him that I should be able to compile and send a .minecraft folder to him so that we can both play. Unfortunately, he can't find his .minecraft folder where it is supposed to be. Is it hidden and how can I unhide it? This is problem #6 from Section 1.2 of Ash's Real Variables With Basic Metric Space Topology.   I am asked to show that it is impossible to list the rational numbers in increasing order.   While I know it is possible to list a finite subset of the rational numbers in increasing order, I was wondering if the reason for the impossibility in this case is because there is no least element of $\mathbb{Q}$?   I mean, it's possible to impose an ordering on $\mathbb{Q}$ (correct me if I'm wrong, but it seems possible to compare any two rationals).  But the set $\mathbb{Q}$ is of course, a subset of itself, and the Well-Ordering Principle says that a set $S$ is Well-Ordered only if any subset of $S$ contains a minimal element. Since $\mathbb{Q}$ does not contain a minimal element, it does not appear that it is a Well-Ordered set.   Is this the correct idea as to why it's impossible? If not, could somebody explain to me what the correct idea is and a strategy for proving it?  Thank you ahead of time. Removing trailing newline character from fgets() input How can I start to learn web development? I'm very interested in learning web development and have learned some basics regarding HTML and CSS a few years back from W3Schools, but I never learned how to develop websites that are up to today's standards, i.e. free-flowing sites without the use of tables to govern the design of the site.  What are some good resources that I can start with? Two functions $f:A\rightarrow B$ and $g:B\rightarrow A$. Can someone give me an example where $g\circ f=id_A$ but $f\circ g\neq id_B$? Notation for infinite product in reverse order Prove that $a_{n}=0$ for all $n$, if $\sum a_{kn}=0$ for all $k\geq 1$ Why the Galaxy has 25GB instead of 32GB I just purchased a Samsung Galaxy S3 32GB, when I check the storage I have only 25.5GB. Where is the other 6.5GB? I have my A* pathfinding algorithm right now working such that given a graph it can find the route from one starting node to one goal node.   This works well for many problems, but sometimes I find that multiple goal nodes are valid.  For example, in a game, an NPC might have to go to a switch to shut a door. If there are multiple switches that shut the door in question, it doesn't matter which switch it goes to - it just needs to go to one of them.  How can I augment my pathfinding algorithm to find the path to the best goal (the shortest path)? As in, the algorithm searches for multiple goals and when it finds just one, it returns the path to that one.  One solution would be to run the algorithm as many times as there are valid goals, but you can guess why that might be inefficient. I have multiple polygons, all located offshore around the UK. I am trying to calculate the areas of these polygons in square kilometres, without splitting them by UTM zone.  Is it possible to do this accurately? I have been using World Mercator, but there are big distortions at this scale. If the polygons were limited to the east coast, say, I would use UTM31N. However, as they are all over the UK waters, I am unsure what to use.  Is there a coordinate system that covers this area? British National Grid does not extend far enough out to sea to be of use.