I want to find all Foos that do not have any associated Bars.  Here's the query I'm using.  It's returning no records:  select * from foos f where f.id not in(select b.foo_id from bars b);   However, I know that the foo with id = 1583 has no associated Bars, so there should be at least one result in my previous query.  Can somebody point out a mistake I am making?  Thanks.
When I have a query that checks if a column of type uniqueidentifer does not exist in a table that has a null value then I get no results back. If the subquery does not return a null it works fine and it only happens when using not in.   I know I can just do a not null check in my subquery, but I am curious why this does not work.  Query Example:  select a.guid from tableA a where a.guid not in (select b.guid from tableB AS b)   Working Test:  select 1 where newid() not in (select newid())   Broken Test:  select 1 where newid() not in (select null)
On SO, when I'm scrolling through "questions" some have a yellow background.  Is this intuitive to everyone but me?  What is the yellow background trying to tell me about this particular question? Minecraft 1.7.4 server issues with loading world I want to use Google Chrome and Google search instead of Bing when I search in Windows 10.   Google Chrome is launched when I click on web, but it's Bing search. (My default search engine on Google and Edge is )    I haven't found how to configure that.  Someone can help me ? I'm trying to wrap my head around this very Hello World-y problem in game development. I've created a TicTacToe game in XNA so I guess the next step would be a  clone.  Keep in mind that I have no knowledge on game programming or even what maths I should apply to where. That's why I'm asking this question.    To the question: How can I determine where the ball should bounce when it hits the paddle at the bottom of the screen?  I'd imagine it would be something like:   Capture speed and angle from incoming ball. Detect where it touched the bar (far left, far right, center) and according to that give it a higher speed if it touched the outer areas. This is where I'm stuck. Hehe.   Any insights? I realize this is not a straightforward answer type question, but I'm sure it's one everyone faces at some point.  I'm reading the book Linear Algebra that was recommended on this website, but I still have no idea if I should apply it here. I can't figure out how to line up the symbols of an itemize environment in beamer with the left part of the main text. In other words, I would like to supress the left margin in beamer itemize lists.  It would be nice if the solution worked with any itemize label defined with  \setbeamertemplate{itemize item}[]   In order to make myself clearer, what beamer produces by default is something like:  Main text. Main text. Main text...    * Item 1    * Item 2    * Item 3    ....   and the desired result is   Main text. Main text. Main text... * Item 1 * Item 2 * Item 3 .... Can an inanimate thing lift Mjolnir? Can an inanimate thing can lift Mjolnir without the help of a living being (unworthy)  Scenario 1  Mjolnir in a very light car with a sail attached to it, then a very strong wind blew and moved the car uphill.  It is possible or not?  Scenario 2  Can upward wind alone lift the Mjolnir? Inequality involving the integral of vector valued function Suppose $f :[a,b]\to \mathbb{R}^n$ is given by $f(t)=\langle f_1(t), \ldots, f_n(t)\rangle$, where each of the $n$ component functions is integrable over $[a,b]$. I think the following inequality   $$\left|\int _a^b f(t) \, dt\right|\leq\int_a^b\left|f(t)\right| \, dt$$  still hold but I don't know how to prove it. Any idea?  Thanks Which manuals are on your "TeX Reference" shelf? This is a community wiki since there is no "one true answer"- if you find an answer that contains a lot of your choices, but is missing something you feel is incredibly useful.  Feel free to add it.  A short description of what topics the reference covers would be nice as well.  Organize by subject please.  For example: I always keep the following PDFs at my fingertips.  Document Layout   :  Covers, in exquisite detail, how to produce just about any document using the memoir LaTeX class. ( 4.5 MB)   Mathematical Typesetting   : A document by Herbert Voß that explains how to typeset just about any mathematical expression in LaTeX. ( 2 MB)   Graphics   : Explains, with examples, how to draw just about any figure using PGF/TikZ.  Also a good example of what awesome documentation should look like. ( 9.5 MB) HP Easy Scan - "HP Scanner 3" will damage your computer Separate long math text under sum symbol into different lines? Why are we limited to six questions per day? I am trying to run some unit tests in a C# Windows Forms application (Visual Studio 2005), and I get the following error:  System.IO.FileLoadException: Could not load file or assembly 'Utility, Version=1.2.0.200, Culture=neutral, PublicKeyToken=764d581291d764f7' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)** at x.Foo.FooGO() at x.Foo.Foo2(String groupName_) in Foo.cs:line 123 at x.Foo.UnitTests.FooTests.TestFoo() in FooTests.cs:line 98** System.IO.FileLoadException: Could not load file or assembly 'Utility, Version=1.2.0.203, Culture=neutral, PublicKeyToken=764d581291d764f7' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)  I look in my references, and I only have a reference to Utility version 1.2.0.203 (the other one is old). Any suggestions on how I figure out what is trying to reference this old version of this DLL file? Besides, I don't think I even have this old assembly on my hard drive. Is there any tool to search for this old versioned assembly? Why do regex constructors need to be double escaped? Proving that if $V$ is an inner product space and $U_1, U_2$ are subsets, then $U_1 \subset U_2$ if and only if $U^{\perp}_2 \subset U^{\perp}_1$ Possible Duplicate:          I have been downvoted for few answers of mine and the person who downvoted me did not leave any comments or reasons to say why I was downvoted. In such cases, how can I find out who has downvoted me and the reason for downvoting? I found a video on YouTube that shows someone using the command tasksel from the server's boot menu after a fresh install of Ubuntu Server. Simple enough it looked like, but when I go to the options I want to choose for installation it has no information on how to select them, and when I click Enter on one of them it takes me back to the command prompt.  So how do I make a selection of the items listed under tasksel?  I have tried Shift++ to add, but no luck. Anyone know?  I want to install Ubuntu Desktop, as Ubuntu GNOME GUI is not an option in the listing for Ubuntu 17.10 Server. I have often heard people say "x of his" or "x of mine". But since his and mine point out ownership, isn't using "of" here doubles that ownership? Wouldn't it be more appropriate to say "x of him" or "x of them" etc.?  Example:     I was a good friend of your dad's. He told me all about you` TP-LINK TL-WN823N Unable to connect to network etoolbox and tabularx -- problem with `appto` I'm trying to print worksheets. I have already implemented an automatic numbering for subtasks. I use tabularx for my subtasks (see the MWE below).  Yesterday, I tried to define a new macro called \task that has one optional argument which is the amount of points you can obtain for this particular question. I would like these optional arguments to be gathered with etoolbox's \appto command so that I can print them with my \credits command.  So far, this seems to be ind of struggling as tabularx is working on the tables several times. Every time tabularx calculates the width of X columns the points are appended to \credits which leads to an incorrect list of points.  Is there any way I can solve this problem? I'm currently stucked with this issue.  Plus, I don't know why my \task command does work. Why is the counter subtask not affected by tabularx's several trials?  \documentclass{scrartcl}  \usepackage[utf8]{inputenc} \usepackage[T1]{fontenc}  \usepackage{etoolbox} \usepackage{booktabs} \usepackage{ltablex} \usepackage{xifthen}  \def\credits{} \newcounter{subtask} \setcounter{subtask}{1} \renewcommand{\thesubtask}{\alph{subtask})} \newcommand{\task}[1][]{%     \ifthenelse{\isempty{#1}}{%         \thesubtask%         \stepcounter{subtask}%     }{%         \thesubtask%         \gappto\credits{(#1)}%         \stepcounter{subtask}%     }% }  \begin{document} \begin{tabularx}{\linewidth}[l]{l@{\hspace*{1ex}}X}     \task[1]    &amp;   TEXT1\\     \task       &amp;   TEXT2\\     \task[3]    &amp;   TEXT3 \end{tabularx} \credits \end{document}       The solution given by David Carlisle below causes a table that is too wide. How can this be undone?  \documentclass{scrartcl}  \usepackage[utf8]{inputenc} \usepackage[T1]{fontenc}  \usepackage[a6paper, showframe=true]{geometry}  \usepackage{etoolbox} \usepackage{booktabs} \usepackage{ltablex} \usepackage{xifthen}  \def\credits{} \newcounter{subtask} \setcounter{subtask}{1} \renewcommand{\thesubtask}{\alph{subtask})} \makeatletter \newcommand{\task}[1][]{%     \ifx\hfuzz\@tempdima% %   % tabularx trial do nothing     \else%         \ifthenelse{\isempty{#1}}{%             \thesubtask%             \stepcounter{subtask}%         }{%             \thesubtask%                 \gappto\credits{(#1 BE)\\}%             \stepcounter{subtask}%         }%     \fi } \makeatother   \begin{document}  \begin{tabularx}{\linewidth}[l]{l@{\hspace*{1ex}}X}     \task[1]    &amp;   Some longer text that exceedes the line width.\\     \task[4]    &amp;   TEXT2\\     \task[3]    &amp;   TEXT3 \end{tabularx} \credits  \end{document} LAN not working on 17.04 Actually yesterday I've upgraded from Ubuntu 16.04 to 17.04 and I got a problem that, if connect LAN cable it does not showing anything and  remains disconnected. But i can connect with WiFi. I don't know what's the problem. Actually its showing "device not managed" under the "Ethernet Network" and both were disabled. I've searched for the solution, but did not found yet.