Convert Month Number to Month Name query in SQL? In my table date format is 2011-06-23, but i want to show the month name in string type, like Jan, Feb e.t.c.
Convert Month Number to Month Name Function in SQL I have months stored in SQL Server as 1,2,3,4,...12. I would like to display them as January,February etc. Is there a function in SQL Server like MonthName(1) = January? I am trying to avoid a CASE statement, if possible.
Importing users that will be installed by programs I know that a gas is made of atoms or molecules moving freely in space.  When these particles hit the walls of where they're kept in they cause something called pressure.  But these particles never pile up on each other and push a surface down by their weight so that we can measure it as weight, not pressure.  So why do gases have weight? Texture mapping with multiple UV maps So, as a newbie relatively new to blender, I started doing some texture mapping (blender internal Render). I created a texture for the main object and a couple of transparent decals to decorate it. (basic effects made in GIMP). Simple stuff, just to know how it works.  After unwrapping, having 2 UV maps made, creating both new material and textures, enabling UV mapping coordination I always end up with:  - all - 1 faces of the cube being covered nicely in the main texture  - 1 face covered in blank material with a decal in the middle of it  - the whole thing partly coated by a huge "stain" of a decal  So, the problem is that I can't layer textures correctly. Is there a way to have one texture covering everything and more transparent ones on top of it? I am working on a bigger project right now and having this ability would be useful What is the difference between HTML tags  and ? I would like to ask for some simple examples showing the uses of &lt;div&gt; and &lt;span&gt;.   I've seen them both used to mark a section of a page with an id or class, but I'm interested in knowing if there are times when one is preferred over the other. I have an excel spreadsheet with header and survey drill data. Header data contains hole ID, and location coordinates, and the survey data contains related downhole survey with Distance, Azimuth and Dip values.   Since I know the hole location and surface elevation, I would like to be able to convert the survey table to XYZ coordinates as well.  Does anyone has a function / procedure / example?  (VB &amp; ArcObjects)  Header Data:    Survey Data: Determining likely relationship based upon autosomal DNA shared cM Given two tests that share some cM of autosomal DNA, how can I easily find the predicted relationships that such shared cM would suggest? For example, a 2,200 cM match suggests it could be either: grandparent, half-sibling, or grandchild. Decrease Backlight Below Minimum I have this laptop that doesn't handle the backlight very well.  In /etc/default/grub, I have added a acpi_backlight=vendor function to get it to work at all. Which is cool, and the backlight now actually works, but the minimum backlight setting is still pretty high.  Is there any way to decrease the backlight below minimum? I don't mind having to type in the terminal to do that, as I won't need to do it often (just at night etc.) In programming terminology, what do you call the difference between these instructions: Enable SSO for Salesforce Marketing Cloud I need to enable Single Sign On for Salesforce Marketing Cloud account where Identity Provider will be a third party and Marketing Cloud will be the Service Provider. I already got SSO Metadata option enabled for my account. I however, need an Entity ID and Federation ID. I am not clear about how to carry the entire process. If anyone of you guys has done SSO enabling for Marketing Cloud, please share steps. Select top 10 records for each category I want to return top 10 records from each section in one query. Can anyone help with how to do it?  Section is one of the columns in the table.  Database is SQL Server 2005. I want to return the top 10 by date entered.  Sections are business, local, and feature.  For one particular date I want only the top (10) business rows (most recent entry), the top (10) local rows, and the top (10) features. Why should boostrap sample size equal the original sample size? When searching the internet on the sample size of for boostrap samples I generally find that the size should equal the original sample size. However, I can't find any explanation on why this should be the case.   In what way is it bad to use a smaller sample size? Is it always better to use a larger sample size?   Some of the sites which report this: How long does Alchemist's Fire burn? Looked and looked, can't find the answer anywhere (maybe I'm blind):  How long does Alchemist's Fire burn for?  In the item description within , it says:     On a hit, the target takes 1d4 fire damage at the start of each of its turns. A creature can end this damage by using its action to make a DC 10 Dexterity check to extinguish the flames.   Yet no mention of the burn rate.  One round after a hit?  2?  A minute?  Continuous until extinguished? How does Princess Leia know Obi-Wan Kenobi is "Ben" Kenobi? When Luke rescues Leia from her cell on the Death Star:  Leia: Aren't you a little short to be a stormtrooper? Luke: Huh? Oh, the uniform. I'm Luke Skywalker. I'm here to rescue you. Leia: You're who? Luke: I'm here to rescue you. I've got your R2 unit, I'm here with Ben Kenobi! Leia: Ben Kenobi, where is he?! Luke: Come on!  How does Princess Leia know Obi-Wan Kenobi is &quot;Ben&quot; Kenobi? Shouldn't her response have been: &quot;Ben Kenobi? You mean the General??&quot; Let $\{K_n \}_{n \in \mathbb{N}}$ be a collection of sets, where $K_n = [n, \infty)$. Why is $\bigcap_{n \in \mathbb{N}} K_{n}$ empty? This question is related to Exercise 2.15 in Baby Rudin, in which the reader is instructed to "[s]how that Theorem 2.36 and its Corollary become false (in $R^1$, for example) if the word 'compact' is replaced by 'closed' or by 'bounded.'"  The relevant theorem and corollary are as follows:  Theorem 2.36: If $\{K_{α}\}$ is a collection of compact subsets of a metric space $X$ such that the intersection of every finite subcollection of $\{K_{α}\}$ is nonempty, then   $\{K_{α}\}$ is nonempty.  Corollary: If $\{K_{n}\}$ is a sequence of nonempty compact sets such that $K_{n}$ contains $K_{n+1},  (n = 1, 2, 3, ...)$, then   $K_n$ is not empty.  My Question: I realize this question and similar ones have been asked elsewhere on MSE, but I've yet to see a straightforward (to me, at least) answer to my question specifically. Usually, for the "closed" part of the exercise, the following collection of closed sets, $\{K_n \}_{n \in \mathbb{N}}$ is used:  $$K_n = [n, \infty), n \in \mathbb{N}.$$  For, the intersection of every finite subcollection of ${K_n}$ is clearly nonempty. Indeed,  $$ \bigcap_{i=1}^{m} K_{n_{i}} = [N, \infty) $$  where $N = \max\{n_1, n_2, ..., n_m\}$.  Then, the assertion is made that   $$ \bigcap_{n=1}^{\infty} K_n = \emptyset. $$  However, I don't see how the same argument can't simply be used, i.e., that, for example, $N \in  \bigcap_{n=1}^{\infty} K_n$ (or maybe, say, $n+1$). Intuitively, this certainly makes sense, I'd say. For, given the archimedean property, it seems that as $n$ approaches infinity, we can always find an $l$ in each increasingly smaller set such that $n &lt; l &lt; \infty$; and so $l \in  \bigcap_{n=1}^{\infty} K_n$.  What is it exactly that I'm misunderstanding or overlooking here? Line breaking with hyperref href with an underline in itemize I have a simple itemized list like the following MWE:  \documentclass[10pt,a4paper]{article} \usepackage[utf8]{inputenc} \usepackage{amsmath} \usepackage{amsfonts} \usepackage{amssymb} \usepackage{graphicx} \usepackage{hyperref} \usepackage{lmodern} \usepackage[left=2cm,right=2cm,top=2cm,bottom=2cm]{geometry} \usepackage{lipsum} \begin{document} \begin{itemize} \item \href{http://google.com}{[ID1]: \underline{\lipsum[1]}} \end{itemize} \end{document}   This unfortunately doesn't break the block of text as expected, as shown below:    How can I fix this item so it will line break properly? Relationship between complex number and vectors How was Nearly Headless Nick unpetrified? How does ServerName and ServerAlias work? Scanning Java annotations at runtime What is the best way of searching the whole classpath for an annotated class?  I'm doing a library and I want to allow the users to annotate their classes, so when the Web application starts I need to scan the whole classpath for certain annotation.  Do you know a library or a Java facility to do this?  Edit: I'm thinking about something like the new functionality for Java EE 5 Web Services or EJB's. You annotate your class with @WebService or @EJB and the system finds these classes while loading so they are accessible remotely. Will I die if I lose enough life to kill me from an effect that also heals me? What happens if I dip below 1 life from an effect that will also heal me after the damage is dealt?  For example:   If I bolt myself while I'm at 3 or less with a  on the board? Will I die while at 3 or less if I -2 , targeting myself? Will I die if a creature with my  on it damages me? Will I die if I target myself with enough damage to 'kill' me with a ?   and so on and so forth. You get the idea. I'm pretty sure there's a relatively simple answer that I just don't know about.