SQL Server T-SQL - Convert INT e.g. 201211 value to Nov 2012 during select
Convert Month Number to Month Name Function in SQL
Using continuous color band for raster legend in QGIS composer legend? I'm looking for a way to insert continuous colour legend for a raster layer.  I managed to create discrete symbols with values along the bar, but I would like to have a continuous bar with some values on the bar, similar to the old plugin "One-Band Raster", that it doesn't work with the QGIS version higher than 1.7  I tried to set in properties->style, where I selected the  Render Type "Singleband pseudocolor" and see the "generate new color ramp" box.  I tried both "Continuous" or "Equal interval". However, in the Composer the legend always is displayed with discrete symbols.  Is there any way that can make QGIS Composer to display a nice continuous band for a raster layer? How to compute moments of log normal distribution? The computed moments of log normal distribution can be found . How to compute them? Drift velocity in Drude model After upgrading to Ubuntu 17.10 I noticed some of my screencasting applications are not working, for example screencasting tools like SimpleScreenRecorder and vokoscreen. ()  Also I noticed features like screenshot from GIMP is not working properly, producing blank screenshots (). Shutter too is producing glitchy screenshots ().  Screen-sharing option on Skype is also not working ().  The issue occurs sometimes on later Ubuntu releases too.  Why is this happening and how do I fix this? rsync and symbolic links I want to backup my home directory to an external drive nightly using a cron job to execute rsync.  I am unsure of the exact behavior of rsync's symbolic link flags.   rsync's -a flag includes the -l flag (i.e. "copy symlinks as symlinks").  Does this just mean it will copy the link or that it will follow the link and copy everything in the link-to directory?  I want to avoid that because I have links to directories full of media files that would involve copying hundreds of gigabytes I don't need to back up. Fearing (but not certain) that rsync -a would copy all those media files I instead added the --no-links flag.  This does not seem to be behavior I want.  It just ignores copying any link which is problematic because I do have links I want copied (e.g. links to common header files from different project directories). Assuming #1 above (without the --no-links flag) is what I really want and it just copies the link without copying the linked-to files, will the links break when they are backed up?  For example I may rsync source directory /home/me/projects/misc to /media/extdrive/backup/home/me/projects/misc.  In this case I assume rsync is not smart enough nor does it try to correct the contents of symlinks for the relative directory changes.  Is this correct?  This is okay, it doesn't matter if the links are broken in the backup directories so long as they would be fixed and working if such time comes when they need to be restored. Why do we need virtual functions in C++? How to change this matrix with respect to standard basis? Given the basis $\beta = \{ (1, 1, 0),\ (1, 0, -1),\ (2, 1, 0)\}$ and the matrix:  $$ A =         \begin{bmatrix}         1 &amp; 1 &amp; 0 \\         1 &amp; 1 &amp; 0 \\         0 &amp; 0 &amp; 1 \\         \end{bmatrix} $$  with respect to  $\beta$.  How to change this matrix with respect to standard basis? $(m, m+2)$ is twin prime, iff $4((m-1)! + 1) \equiv -m \pmod {m(m+2)}$ The Wiki page on  says     The pair $(m, m+2)$ is twin prime, iff $4((m-1)! + 1) \equiv -m \pmod {m(m+2)}$.   This is obviously connected to Wilson's Theorem. Can anybody provide a proof for that, along the lines of thought given here, ? Datepicker returning uncaught typeError: undefined 'currentDay' Steam not opening in Ubuntu 16.04 LTS I have never used Ubuntu or any other Linux OS before last Friday. For all I know, I might have installed Ubuntu wrong and be missing a component. I would prefer if you use simplest terminology possible, but I'm OK with doing a bit of googling if need be. I just installed Steam for Ubuntu 16.04 but it won't open when I click on it in the launcher. The icon flashes for a few seconds, stops and then nothing happens. I looked in the system monitor and steam shows up there but ending the process and trying again does nothing. I heard trying to open apps that aren't working through the terminal tells you what the error is so I tried that and I got this:  Running Steam on ubuntu 16.04 64-bit STEAM_RUNTIME is enabled automatically Installing breakpad exception handler for appid(steam)/version(0) libGL error: unable to load driver: radeonsi_dri.so libGL error: driver pointer missing libGL error: failed to load driver: radeonsi libGL error: unable to load driver: swrast_dri.so libGL error: failed to load driver: swrast   Please help I just want to play CS:GO again. I have a complex integral $$\int_{|z|=r}x \, dz$$ for the positive portion of the circle.  I know that this integral seems easy enough but I am having trouble with it, and I'm fairly certain my answer is incorrect.  I wanted to use a parameter such that $x=r\cos\theta$, so we then have $dz=dx+i\,dy=dx$ since there is no reason to have have the $i\,dy$ since the imaginary part is equal to $0$.  So now I have the double integral  $$\int^r_0\int^\pi_0 r \cos\theta \, dx$$  which equals $0$ since integration the $\cos\theta$ gives $\sin\theta$ and evaluated from $0$ to $\pi$ makes the integral evaluate to $0$.  Am i misinterpreting part of the question?  Way off base?  The book suggests to also solve the problem by realizing $x=\frac{1}{2}\left(z+\frac{r^2}{z}\right)$ along the circle.  For this portion of the problem I assume that I would integrate the above by $z$ as if it were a normal calculus problem, but I have problems with what to put as upper and lower limits.  Thanks in advance! Surjective, Injective, Bijective Functions from $\mathbb Z$ to itself help you learn vs. help you to learn Source:  by Douglas Crockford (2008) Example:  My goal here is to help you to learn to think in JavaScript. I will show you the components of the language and start you on the process of discovering the ways those components can be put together.  Although it is usually the case that you mostly hear people say something like &quot;this will help you become a better person&quot;, is there any particular reason as to why he chose not to leave out the to and say help you to learn instead? If you've got something interesting to say, could you please elaborate on it as well? I would very much like to receive some coherent explanation and get this thing finally straight. The only time I know of, though, that you would use the to is when you say it like this:  It helps a lot to think of the rather difficult concept of classes used in modern software development as mere blueprints that architects and builders use to build houses. In life, it really helps to know your times tables by heart because not all the time do you have a calculator on you.  Because the aspect of the verb &quot;help&quot; is a little bit different here. But in all other cases, help do or help you do something is by far more common. Brief Description:  I need my Ethernet card (en0) to see all traffic under 192.168.2.xxx.  However I also need to use WiFi card (en1) for all other traffic.  OS: OS X Lion    I am using a separate network location to deal with this specific use (since this is a for a robotics project that communicates via Ethernet). Ethernet (en0) had to be set up as a static IP (192.168.2.10) per the requirements for the device I am connecting to. All connections on the Ethernet card (en0) should be 192.168.2.xxx as specified above. WiFi (en1) is set up as DHCP to a router since their is no point in assigning it as a static for general purpose traffic. Ethernet (en0) is set up as priority over WiFi (en1).  I would also like to keep this under the network location preferences if at all possible since I do not require this feature to be on all the time.  I would really appreciate your help on this. No one I have talked to knows how to solve this. I'm trying to install the flashybrid but when I enter the apt-get install flashybrid command, I get this error:  root@user-desktop:/home/user# apt-get install flashybrid Reading package lists... Done Building dependency tree Reading state information... Done flashybrid is already the newest version. 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 1 not fully installed or removed. After this operation, 0B of additional disk space will be used. debconf: DbDriver "config": /var/cache/debconf/config.dat is locked by another process: Resource temporarily unavailable Setting up flashybrid (0.15+nmu2) ... debconf: DbDriver "config": /var/cache/debconf/config.dat is locked by another process: Resource temporarily unavailable dpkg: error processing flashybrid (--configure): subprocess post-installation script returned error exit status 1 Errors were encountered while processing: flashybrid E: Sub-process /usr/bin/dpkg returned an error code (1)   I also tried this one to find what is already using that file:  root@user-desktop:/home/user# lsof | grep /var/cache/debconf/config.dat lsof: WARNING: can't stat() fuse.gvfs-fuse-daemon file system /home/user/.gvfs Output information may be incomplete. dpkg-prec 4672 root 4rW REG 8,6 39658 1697827 /var/cache/debconf/config.dat   But I don't know how to fix this. On this link (Sentinel1  for a SLC product), the resolution is written as a range from the highest corresponding to low incidence angle, to the lowest resolution corresponding to high incidence angle.  My question is how is the resolution related in general to the incidence angle? And if they are really related, why is the resolution affected by the change in the incidence angle? "PuTTY key format too new" when using ppk file for PuTTY SSH key authentication I wanted to connect to my Unix server using SSH keys. For that I had converted my id_rsa file from ./ssh directory to a ppk file using PuTTYgen, but after loading my .ppk key I get this warning:  PuTTY key format too new   If I use my default id_rsa file, then I get error:  OpenSSH SSH-2 private key (old PEM format)  Either way I am getting stuck. Can anyone please help me? What is a complete book for introductory quantum field theory? There's a fairly standard two or three-semester curriculum for introductory quantum field theory, which covers topics such as:   classical field theory background canonical quantization, path integrals the Dirac field quantum electrodynamics computing $S$-matrix elements in perturbation theory, decay rates, cross sections renormalization at one loop Yang-Mills theory spontaneous symmetry breaking the Standard Model   What is a good, complete and comprehensive book that covers topics such as these? How to prove a general matrix invertible given by as below?  How to prove that $A^TA+I$ is always invertible for $\forall A \in \mathbb{R}^{n\times n}$? Why don't electrons crash into the nuclei they "orbit"?