Where, and how, do I install multiple packages stored in a local directory?
How do I install a .deb file via the command line?
SQL Select Upcoming Birthdays I'm trying to write a stored procedure to select employees who have birthdays that are upcoming.    SELECT * FROM Employees WHERE Birthday &gt; @Today AND Birthday &lt; @Today + @NumDays  This will not work because the birth year is part of Birthday, so if my birthday was '09-18-1983' that will not fall between '09-18-2008' and '09-25-2008'.    Is there a way to ignore the year portion of date fields and just compare month/days?   This will be run every monday morning to alert managers of birthdays upcoming, so it possibly will span new years.    Here is the working solution that I ended up creating, thanks Kogus.    SELECT * FROM Employees  WHERE Cast(DATEDIFF(dd, birthdt, getDate()) / 365.25 as int)     - Cast(DATEDIFF(dd, birthdt, futureDate) / 365.25 as int)  &lt;&gt; 0 How to run both Intel and Nvidia graphics card driver on dual monitor setup? I'm trying to get Intel and Nvidia graphics card working together with two monitors. One monitor should use the Intel card and the other the Nvidia card. Of course, I want to use only one keyboard and one mouse to switch between both screens. Bumblebee didn't work for me.  I don't want to use the xserver-xorg-video-all package because I need the Nvidia card for gaming and I can't use only one graphics card because I need one for KVM virtualisation and the other one for my Linux desktop  So I tried to install the drivers and to configure the Xserver manually. The Nvidia driver is working and I get a video output. But I don't get a video output with the Intel card.  I followed   The config files: The warlock's Thirsting Blade eldritch invocation cannot be normally used with the (non-warlock) class feature Extra Attack, since both feature explicitly say you attack twice instead of once. But it seems to me that you could use both features (if you have them) when using Two-Weapon Fighting.  Assume your character is wielding two light weapons, one of which is your pact weapon. You take the Attack action on your turn to attack twice with your non-pact weapon using your  class feature.  Then, given the Two-Weapon Fighting rules, you use your bonus action to attack once using your pact weapon this time.  The  rules (PHB p. 195) state:     When you take the Attack action and attack with a light melee weapon that you're holding in one hand, you can use a bonus action to attack with a different light melee weapon that you're holding in the other hand.   But since your have the Thirsting Blade invocation, and you used the Attack action, you get to attack twice with your pact weapon.  The Thirsting Blade  (PHB p. 111) says:     You can attack with your pact weapon twice, instead of once, whenever you take the Attack action on your turn.   Does this combo work within the rules, or is there any interaction I'm not aware of? Pluralization rule for "five-year-old children", "20 pound note", "10 mile run" pgfplots: correct rounding problems I had a problem with disappearing marker as the data sum up to more than 100 while xmax was set to 100. See .  As written in the answer to the cited question I tried to avoid the problem by normalizing the value to 100. But this lead to (much smaller) rounding errors in previously correct rows and now the marker disappear there. See the following example. Before the normalisation the column F ist affected, after the column B.   How can I in a reliable way avoid this rounding problem? Or at least get a clear error message. I have quite a number of this plots and I don't want to have to check them all the time for missing markers.    \documentclass{scrreprt} \usepackage{pgfplots} \pgfplotsset{compat=1.13} \usepackage{pgfplotstable} \pgfplotsset{  my stackbar plot/.style={              xbar stacked,              xmin=0,xmax=100,              symbolic y coords={A,B,C,D,E,F,G},              ytick=data,              nodes near coords={xxx},}}  \begin{document}  \pgfplotstableread[col sep=space]{  text   --  -    +       ++  A      0.0 1.7 13.8    84.5  B      0.0 0.6 20.1    79.3  C      0.0 1.9 13.2    84.9  D      0.0 1.6 27.9    70.5  E      1.3 3.9 19.5    75.3  F      0.0 1.4 15.0    83.7  G      0.3 1.7 24.8    73.2  }\data   \pgfplotstablecreatecol[create col/expr={\thisrow{--}+\thisrow{-}+\thisrow{+}+\thisrow{++}}]{sum}\data %  \pgfplotstablecreatecol[create col/copy=--]{--o}\data  \pgfplotstablecreatecol[create col/copy=-]{-o}\data  \pgfplotstablecreatecol[create col/copy=+]{+o}\data  \pgfplotstablecreatecol[create col/copy=++]{++o}\data  \pgfplotstablecreatecol[create col/expr={100/\thisrow{sum}*\thisrow{--o}}]{--}\data  \pgfplotstablecreatecol[create col/expr={100/\thisrow{sum}*\thisrow{-o}}]{-}\data  \pgfplotstablecreatecol[create col/expr={100/\thisrow{sum}*\thisrow{+o}}]{+}\data  \pgfplotstablecreatecol[create col/expr={100/\thisrow{sum}*\thisrow{++o}}]{++}\data  \pgfplotstablecreatecol[create col/expr={\thisrow{--}+\thisrow{-}+\thisrow{+}+\thisrow{++}}]{sumnew}\data  \pgfplotstabletypeset[columns={text,sum}   ,precision=10,columns/text/.style={string type}]\data \quad \pgfplotstabletypeset[columns={text,sumnew},precision=10,columns/text/.style={string type}]\data   %\pgfplotstablesave{\data}{pgfplotstempout.dat} \begin{tikzpicture} \begin{axis}[my stackbar plot]  \addplot table [x expr = \thisrow{--o},y=text] {\data};  \addplot table [x expr = \thisrow{-o}, y=text] {\data};  \addplot table [x expr = \thisrow{+o}, y=text] {\data};  \addplot table [x expr = \thisrow{++o}, y=text] {\data}; \end{axis} \end{tikzpicture} \quad \begin{tikzpicture} \begin{axis}[my stackbar plot]  \addplot table [x expr = \thisrow{--},y=text] {\data};  \addplot table [x expr = \thisrow{-}, y=text] {\data};  \addplot table [x expr = \thisrow{+}, y=text] {\data};  \addplot table [x expr = \thisrow{++}, y=text] {\data}; \end{axis} \end{tikzpicture}  \end{document} "Whether" Vs. "If" Could someone please help me with these sentences? I need to know  Which one doesn’t sound natural? Which one is formal and which one is not?   A - I don’t know whether this word fits in the sentence. B - I don’t know if this word fits in the sentence.   C - I don’t know whether or not this word fits in the sentence. D - I don’t know if or not this word fits in the sentence.   E - I don’t know whether this word fits in the sentence or not. F - I don’t know if this word fits in the sentence or not.  For me only D doesn't work and sounds not idiomatic. Meanwhile for me all of these sentences can be used in both written and spoken languages. Do you confirm me? Exercise 12 from SEC. 82 of Finite-Dimensional Vector Spaces - 2nd Edition by Paul R. Halmos.  If $A$ and $B$ are linear transformations on a finite-dimensional inner product space, and if $\textbf{0} \le A \leq B$, then $\det A \leq \det B$.  Notation: $0 \le A$ means that $A$ is positive.  If $\det B = 0$, choose $x \in \ker B$, then $0 \le ((B-A)x,x) = (Bx, x) - (Ax, x) = -(Ax, x) \le 0$. Therefore $\ker B \subseteq \ker A$ and $0 = det A \le det B = 0$. How to prove for the case when $B$ is invertible? Intuitively, I feel that since both $A$ and $B$ are positive their proper values are also positive and $B$'s proper values should be greater the $A$'s and same for determinants. Custom first page with fancyhdr I'm using the package fancyhdr to format my footers and headers, with my name in the header and a n of m pages format for the footer. Like so:  \pagestyle{fancy} \fancyhf{} % clear all header and footer fields \fancyhead[C]{Name} \fancyfoot[C]{\footnotesize Page \thepage\ of \pageref{LastPage}}   By default, the fancy page style only affects the pages after the first page. I know I can set the first page to the fancy page style using \thispagestyle, but I only want the first page to use the footer, not the header. Is there a way to create a custom style that just the first page will use? Do I need a visa for a connecting flight to Japan? I'm going to the Philippines this October and would like to layover in Japan. I found a reasonably priced ticket with a 15-hour layover to Haneda, however, I have to transfer to Narita. Do I need a visa since I'm going to have to stay at a hotel and ride a bus to travel to Narita airport? Thank you! Show Kripke's model proving that the following formula isn't tautology in intuitionistic logic. $ \neg ( p \wedge q ) \implies (\neg p \vee \neg q) $  Please help/hint me ;) What would you call a word that doesn't exist in or translate well into another language? I've run into this situation several times, being a native Spanish speaker.   There are some words you just can't translate into another language. Is there a particular word to describe this?  I'm not refering to idioms.  Also, if its a noun, people tend to use them by surrounding them in quotes. Is this appropiate?  Example:     I arrived at around 5 pm and had some quesadillas.   Edit:  I also meant to cover words that exist in English, but cannot be translated into another language.   Example:      There isn't a word for "drive-thru" in your language. Why are comments overlapping the sidebar? On , the comments are overlapping the related questions sidebar. Is this something to do with the weird formatting of the first comment?    Browser: Mozilla/5.0 (Windows NT 6.0; rv:16.0) Gecko/20100101 Firefox/16.0 How is the number / tetris code in Fez intended to be solved? In the same spirit as :   I was able to crack the language code using tradition substitution cipher breaking techniques.  But I ended up cheating on the number/tetris symbols by looking on the Internet.  The number code is logical enough now I know it -- but I can't see how I would have arrived at it without help.  With regard to tetris shapes:      What would cause you to go down the path of associating Tetris shapes with controller inputs? Is there a way to search for a question (or an answer) that mentions a tag? abhigenie92@ubuntu:~$ (sleep 2; echo $BASH_SUBSHELL ;sleep 2) 1 abhigenie92@ubuntu:~$ (sleep 2; echo $BASH_SUBSHELL ;sleep 2)&amp; [1] 3297 abhigenie92@ubuntu:~$ 1  [1]+  Done                    ( sleep 2; echo $BASH_SUBSHELL; sleep 2 )   What happens when launch it as a background process, why don't I get the prompt back and I have to press Enter? In both cases it launches a child shell. Find $a$ such that $(x+a)(x+1991)+1=(x+b)(x+c)$ with $a,b,c\in\Bbb Z$ Find all integer values of $a$ such that the quadratic expression $(x+a)(x+1991)+1$ can be factored as a product $(x+b)(x+c)$ where b and c are integers.   I tried to do it by comparing the two expressions but I can't proceed. How long do you get to use a UK standard visitor visa from time of issue or is it valid for entry indefinite I am going to apply for a standard visitor visa for my girlfriend to enter UK. If it is issued how soon does it have to be used after issue, ie. validity until time of entry? Where does a layman go to get a basic understanding of AKS primality testing. I am not talking about the optimal choice of $r$ (which I am told is the hardcore number-theoretic part of the algorithm). I mean basic things, like what does $\bmod(n, x^r-1)$ mean (how can something be mod two things?) And what does binomial expansion have to do with anything?  I can't find anything in Wikipedia that is appropriate for my level. Code breaks when updating jQuery due to changes in toggle Add air resistance to projectile motion I am given an initial x and y position and initial velocity and I was asked to graph the trajectory in 1 second intervals.  This is what I have so far:  If $x_0 = 1, v_{0x} = 70, y_0 = 0, v_{0y} = 80, a_x = 0, a_y = -9.8$, and time will be 0,1,2,3... and so on.  Using these equations on every second you can find the plot will be a bell shaped with the highest point being ~ 325 m at about 600 seconds:   $$ x = x0 + (v_{0x})t + 1/2((a_x)t^2) $$ $$ y = y0 + (v_{0y})t + 1/2((a_y)t^2) $$  Usually in physics, we are taught in perfect condition with no air resistance. But what if there was air resistance? How would it affect this problem? How can i add it to my calculations and see what the difference is?