Keeps telling me that I'm referencing SubTotal and I'm not sure how to fix that. The error message I'm getting is &quot;Column CHECK constraint for column 'Total' references another column, table 'Job'.&quot; Create Table Job(     JobNumber int not null         Identity (1,1)         Constraint PK_Job primary key clustered,     Date datetime not null,     Address varchar(100) not null,     City varchar(50) not null,     Province char(2) not null         Constraint CK_Province Check (Province like '[A-Z][A-Z]'),     PostalCode char(7) not null         Constraint CK_PostalCode Check (PostalCode like '[A-Z][0-9][A-Z][0-9][A-Z][0-9]'),     SubTotal money not null,     GST money not null,     Total money not null         Constraint CK_Total Check (Total&gt;SubTotal),               /*COME BACK TO THIS */     ClientID int not null         Constraint FK_JobToClient references Client(ClientID),     StaffID int not null         Constraint FK_JobToStaff references Staff(StaffID), )
I have this table but check constraint is throwing me an error:     Column CHECK constraint for column 'MedicamentRegulated' references another column, table 'Medicaments'.   I've seen this as allowed in SQL Server but I don't know why it doesn't work :/  CREATE TABLE Medicaments ( MedicamentID INT NOT NULL IDENTITY(1,1) PRIMARY KEY, Name VARCHAR(50), DateValidity DATE, MedicamentRegulated BIT CHECK((MedicamentRegulated = 1 AND DateValidity IS NOT NULL)    OR MedicamentRegulated = 0) )
Left-align all equations in a block align environment without any explicit alignments points (given by &amp;) right justifies the equations in the block. They can be left justified by putting &amp; at the beginning of each equation. Is there any way to left justify them without starting &amp;-s? Maybe some special environment or option? It seems to be an extra work to tell the compiler again and again that I want left alignment on each line. Do comic characters sometimes get drawn like the actor playing them? I noticed in Spider-Man's recent cameo in Captain Marvel, he appeared an awful lot like Andrew Garfield who is playing Spider-Man in the recent movie.    Irrelevant of whether it is just my imagination, do some depictions of comic characters morph to be more like an actor who plays them around the time a corresponding movie is released?  By comparison, here is Spider-Man's depiction in the Spider-Men crossover: How to prevent LaTeX from line-breaking a phrase? How can I prevent LaTeX from putting line-breaks into a phrase?  I could replace dashes with  and spaces with non-breaking spaces, but I'm looking for a more general solution in case I need other characters in such phrases. I used to have an icon on the Windows Vista taskbar showing the battery amount remaining (laptop). It has mysteriously vanished.  How can I get it back?  I followed the Windows  (see How can I hide the battery icon in the notification area? - hoping to reverse the instructions) but the Power checkbox on the Notification Area tab was greyed out and could not be checked or unchecked (it is currently unchecked). need to make salesforce app available in multiple language I want to make my appexchange app available in multiple language like Spanish, dutch etc. so that depend on the language of the user they can access the app.  Is it possible in any way..  any help will be appreciated.. Thanks Why don't digital cameras shoot video at full sensor resolution, or do continuous drive at video framerates? I have done major updates to my website, and renamed all my URLs.  How can I tell Google that I have renamed these URLs and let Google refresh its index?  My website URL: http://www.pndmasr.com/  My sitemap: http://www.pndmasr.com/sitemap.xml  I have uploaded my sitemap via Google Webmaster Tools many times.  However, every time I search Google for "pndmasr", I still get results with old pages. I have waited more than 3 days but the problem remains. Any suggestions?  Is there a problem with my sitemap? Dwellers return automatically after finding a low amount of items in Wasteland I have a strange thing happening - dwellers I send to explore wasteland are automatically returning to vault after finding a little amount of items (4 or 5).   The exploration log says: "That's as much as I can carry. I better head back and show the Overseer what I found".  Before today they successfully carried up to 30 items and never returned to vault on their own.  I don't know is it relevant or not, but I have a lot of free storage space available.  What caused this change? What can I do to prevent this? Is there a formula for $(1+i)^n+(1-i)^n$? My /boot partition hit 100% and now I can't upgrade. Can't remove old kernels to make room My first issue was when I tried to apt-get update or apt-get upgrade. On upgrade I get the following error:  You might want to run 'apt-get -f install' to correct these. The following packages have unmet dependencies: linux-image-server : Depends: linux-image-3.2.0-27-generic but it is not installed E: Unmet dependencies. Try using -f.   I tried running apt-get install -f and this was the output(after saying yes on prompt)  (Reading database ... 186183 files and directories currently installed.) Unpacking linux-image-3.2.0-27-generic (from .../linux-image-3.2.0-27-generic_3.2.0-27.43_amd64.deb) ... Done. dpkg: error processing /var/cache/apt/archives/linux-image-3.2.0-27-generic_3.2.0-27.43_amd64.deb (--unpack):  failed in write on buffer copy for backend dpkg-deb during `./boot/System.map-3.2.0-27-generic': No space left on device  No apport report written because the error message indicates a disk full error                                                                           dpkg-deb:    error: subprocess paste was killed by signal (Broken pipe) Examining /etc/kernel/postrm.d . run-parts: executing /etc/kernel/postrm.d/initramfs-tools 3.2.0-27-generic   /boot/vmlinuz-3.2.0-27-generic run-parts: executing /etc/kernel/postrm.d/zz-update-grub 3.2.0-27-generic /boot/vmlinuz-3.2.0-27-generic Errors were encountered while processing: /var/cache/apt/archives/linux-image-3.2.0-27-generic_3.2.0-27.43_amd64.deb E: Sub-process /usr/bin/dpkg returned an error code (1)   I tried running apt-get autoremove and it gives me the same error as apt-get upgrade.  When I run df, I get this for /boot:  /dev/sda1                    233191     230297         0 100% /boot   So, I read elsewhere that I should try to purge old kernels. I checked for what kernels I had with:  $ dpkg -l linux-image-\* | grep ^ii ii  linux-image-2.6.38-13-server  2.6.38-13.52  Linux kernel image for version 2.6.38 on x86_64 ii  linux-image-3.0.0-13-server   3.0.0-13.22   Linux kernel image for version 3.0.0  on x86_64 ii  linux-image-3.0.0-14-server   3.0.0-14.23   Linux kernel image for version 3.0.0  on x86_64 ii  linux-image-3.0.0-15-server   3.0.0-15.26   Linux kernel image for version 3.0.0  on x86_64 ii  linux-image-3.0.0-16-server   3.0.0-16.29   Linux kernel image for version 3.0.0  on x86_64 ii  linux-image-3.0.0-17-server   3.0.0-17.30   Linux kernel image for version 3.0.0  on x86_64 ii  linux-image-3.2.0-24-generic  3.2.0-24.39   Linux kernel image for version 3.2.0  on 64 bit x86 SMP ii  linux-image-3.2.0-25-generic  3.2.0-25.40   Linux kernel image for version 3.2.0  on 64 bit x86 SMP ii  linux-image-3.2.0-26-generic  3.2.0-26.41   Linux kernel image for version 3.2.0  on 64 bit x86 SMP   When I try to remove the oldest with this:  $ sudo apt-get purge linux-image-2.6.38-13-server Reading package lists... Done Building dependency tree Reading state information... Done You might want to run 'apt-get -f install' to correct these: The following packages have unmet dependencies: linux-image-server : Depends: linux-image-3.2.0-27-generic but it is not going to be     installed E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).   How can I free up or extend boot without messing up my installation? prove that $24 \mid a(a^2-1)$ If $a$ is an odd integer, prove that $24 \mid a(a^2-1)$.  I proved in my class that $a^2=8k+1$ for some $k$, provided $a$ was odd.  So $$a(a^2-1)=(2k-1)(8k+1-1)=8k(2k-1)$$ but I can't pull a $24$ out of it. Greatest comeback in 2nd leg match GetFeatureInfo from Image WMS I can't find .bash_profile in Ubuntu 14.04 in my /home/user directory. I used the ls -a command to see the .bash_profile, but there isn't such a file. What is inertia of a body? Surface area inside cylinder Find the surface area of the part $\sigma$: $x^2+y^2+z^2=4$ that lies inside the cylinder $x^2+y^2=2y$  So, the surface is a sphere of $R=2$. It looks there should be double integral to calculate the surface, but how, which way? Why isn't Jon executed on sight? So, to get spoilers out of the way -       Jon Snow is too honorable to break his oath and leave the Night's Watch.  However, he is stabbed a bunch, dies, and due to a line in the Night's Watch oath - "It shall not end until my death" - is able to leave without his usual reservation.   Now, this is fine from Jon's perspective.  However, there is a fairly rigid law about the Wall's deserters being punished by death. Which makes me wonder: why isn't Jon having more trouble with this?   He knows what happened, but others don't.  And the explanation that he actually did die doesn't seem like one the lands' lords and authorities would take on faith.  I know I wouldn't.  His story isn't quite like Sam's, who was sent by the Night's Watch to become a maester.  Jon is famous enough that many would know who he is, and that he has taken the black.  But a story like him dying and coming back to life is probably one that takes quite a but of time to stick - if it ever does.  A possible explanation might be that people know Jon is honorable and trust him. Or that they don't care about the law, and think that they can somehow benefit from not executing him - although the law seems to be a strict one, and not everyone seems to be psyched to help Jon out.  Or maybe by that time people coming back to life is a common enough thing that people believe it that easily.  Speculation aside, however, I am curious whether this was directly addressed from the higher-ups - the makers of the show, or the big boss himself.  Why isn't Jon executed on sight? Are Living Beings Turned Into Horcruxes Suceptible to Age, Disease, or Injury? From the HP books I know that Horcruxes grant a form of immortality. So, it is not possible for someone who created a Horcrux to die from old age or succumb to diseases. I guess the same is true for living beings turned into a Horcrux. But do living Horcruxes age normally? Is it possible to cripple them or sever their limbs, head or something like that, or do they instantly "repair" themselves like inanimate Horcruxes? Who is allowed to invite people to a Minecraft Realm? Is the Formula Logically Valid? I have a question for my exam and I find it hard to understand.  I have to prove that the following formula is logically valid:    The professor told me to "push" all the symbols inside the brackets, and use the deduction theorem.  But I don't know how to do it, because I can't find the identities to push the "exist" symbol inside the brackets.  Your help is appriciated, thank you.  Alan