Please imagine someone is going to ask someone else to prepare or find something which its buying and selling is considered as illegal; (i.e. a sort of drug/narcotics - medicine - a type of alcoholic liquor in some religious countries.) Which word would work better in informall language in the self-made sentence bellow:     1) Can you handle a bottle of wine for me tonight?    2) Can you hook me up with a bottle of wine tonight?    3) Can you fix me up with a bottle of wine tonight?    4) Can you line me up with a bottle of wine tonight?    For me, numbers 2-3-4 work, but I have heard once someone used "handle" in this sense in a friendly and informal manner.
Please tell me which choice below (or rather a better choice that I need to know) works better in my sentences in informal English:     I got myself out on a limb. I need to clear my check by tomorrow. No matter how, I must ............ 2 million bucks by tomorrow.   a) line up [to prepare, organize, or arrange something]  b) hook up [hook somebody up with something to help someone get something that they need or want]  c) fix up [to arrange for someone to have something that they need]  For me, all three options work in this sense with the same meaning and informality degree.
Consider the following table:  id  title   genre1  genre2  genre3  genre4  genre5 1   Movie1  Thriller    Crime   NULL    NULL    NULL 2   Movie2  Fantasy NULL    NULL    NULL    NULL 3   Movie3  Political   Philosophical   Historical  NULL    NULL 4   Movie4  Science Fiction NULL    NULL    NULL    NULL   When I unpivot genre1, genre2, ... the NULL values are removed, so that, for example, the rows for Movie1 would be:  id title  genre     original_column 1  Movie1 Thriller  genre1 1  Movie1 Crime     genre2   Is there a way to include NULL values, for example:  id title  genre     original_column 1  Movie1 Thriller  genre1 1  Movie1 Crime     genre2 1  Movie1 NULL      genre3 1  Movie1 NULL      genre4 1  Movie1 NULL      genre5   I can SELECT ISNULL(genre1, '*'), ISNULL(genre2, '*') ..., but suppose I want the values to appear as NULL? Is there a better way than:  WITH  -- SELECT that unpivots table AS unpivoted SELECT unpivoted.id,    unpivoted.title,    ,CASE unpivoted.genre WHEN '*' THEN NULL ELSE unpivoted.genre END    ,unpivoted.original_transaction FROM unpivoted   Also, I notice that the query that returns the source data to be unpivoted MUST have an alias. For example:  SELECT ... FROM   -- *must* give it an alias or it's a syntax error   (SELECT ... FROM) AS source    UNPIVOT(genre for original_column IN (genre1,genre2, genre3,genre4,genre5))   Does anyone know why? I have not found a way to refer to the alias anywhere in the query. Simple question but I am confused.  What is the boundary of $S^2\times\mathbb{R}$? Is it just $S^2$?  What would be the general way to evaluate the boundary of a product manifold?  Thanks for the replies! Windows 10 high memory usage (unknown reason) A few days ago I updated my PC to Windows 10. However, after some use my PC started to slow down until it was impossible to use – it was due to high memory usage. After a restart, everything came back to normal (total usage around 25% of 8GB of RAM). However, during a few hours of usage the memory builds up again to 70%, and if not restarted it further goes to 100%, and later on even freezes. Task manager does not help very much as it does not show all the processes (added screenshots below). Also tried RAMMap but it gives an error: "error refreshing database". I tried Googling this question, yet without much success.  I do not know much about PCs, but maybe some of you know this issue, or could help to find out what is using my RAM. How do you deal with missing players? How to fix pagination for custom loops? I have added a custom/secondary query to a template file/custom page template; how can I make WordPress use my custom query for pagination, instead of using the main query loop's pagination?  Addendum  I have modified the main loop query via . Why isn't pagination working, and how do I fix it? How do I get from Terminal 1 to Terminal 5 in Fiumicino Airport? I don't mean people with low self esteem.  But there are people who feel happy at being able to make other people laugh at their own expense. I remember someone telling me there is a word for them, I can't find it.  Let me explain:  I sometimes, while sitting with a group of people, might just tell them a personal embarrassing story, which might be completely fabricated, to make other people laugh. And when they laugh, I feel happiness.  I'm also self deprecating, but not in a way that I hate myself, rather,  just my work (I'm a screenwriter) and knowing I can do better. I do not self deprecate myself in public (I don't praise myself either).   Edit: Now that its mentioned, I think the word I'm talking about was used to describe a person's sense of humor. Or it could be a word used to describe a psychological trait/disorder.  Edit: I just looked up humor styles on Wikipedia. And after reading it, I guess the word that closely matches what I'm looking for is 'Affiliated Humor' but in a 'Self Defeating' style. I have windows 10 home and from time to time I see a command line window popping up for less than a second. I want to find out which process is causing that. It's not very often that this window pops up so I need some tool that can run for a long time.  Does anyone have a good idea?  Regards Tobias How to keep font preferences in TexWorks 4 The default font is too small on my screen at the resolution I have it, so I like to reset the font to size 12, but it appears I have to do this everytime I launch the program.  How do I make it remember my preferences? Why can't an electric field line suddenly break? My book has the following question in it as an exercise:  An electrostatic field line is a continuous curve i.e. a field line cannot have sudden breaks. Why not?  I cannot seem to be able to reason for or against this statement.  Can somebody please tell me why they can't suddenly break and if that were to happen then what will be its outcome? The shortcode produced by this function - a list of all sites in a multisite - outputs above the content in the loop, no matter where it is placed in the editor.  I've looked at the other related questions and answers on WPSE and realize that it has to do with the function using echo instead of return, but it's not as easy as replacing the instances of echo with return in the function below. Or adding echo=0 with a WP function like wp_list_pages()  Any ideas? Where is the function that needs to be returned instead of echoed?  // Output a single menu item function projects_menu_entry($id, $title, $link_self) {     global $blog_id;     if ($link_self || $id != $blog_id) {         echo '&lt;li&gt;';         if ($id == $blog_id) {             echo '&lt;strong&gt;';         }         $url = get_home_url($id);         if (substr($url, -1) != '/') {             // Note: I added a "/" to the end of the URL because WordPress             // wasn't doing that automatically in v3.0.4             $url .= '/';         }         echo '&lt;a href="' . $url . '"&gt;' . $title . '&lt;/a&gt;';         if ($id == $blog_id) {             echo '&lt;/strong&gt;';         }         echo '&lt;/li&gt;';     } }  // Output the whole menu // If $link_self is false, skip the current site - used to display the menu on the homepage function projects_menu($link_self = true) {     global $wpdb;      echo '&lt;ul&gt;';      projects_menu_entry(1, 'Home', $link_self);      $blogs = $wpdb-&gt;get_results("         SELECT blog_id         FROM {$wpdb-&gt;blogs}         WHERE site_id = '{$wpdb-&gt;siteid}'         AND spam = '0'         AND deleted = '0'         AND archived = '0'         AND blog_id != 1     ");      $sites = array();     foreach ($blogs as $blog) {         $sites[$blog-&gt;blog_id] = get_blog_option($blog-&gt;blog_id, 'blogname');     }      natsort($sites);     foreach ($sites as $blog_id =&gt; $blog_title) {         projects_menu_entry($blog_id, $blog_title, $link_self);     }     echo '&lt;/ul&gt;'; }  // Adds a [bloglist] shortcode  function bloglist_shortcode($atts) {     projects_menu(false); }  add_shortcode('bloglist', 'bloglist_shortcode'); Modal vs Non-Modal vs Auxiliary modal vs Conjugated Verb Modal vs Non-Modal vs Auxiliary modal vs Conjugated Verb   How are these kinds of verb related to each other? Specially Non-Modals and Conjugated Verb. Is the "Auxiliary modal" just another name for "Auxiliary verb"? back commandbutton in jsf Why CTRL + C multiple times I have recently noticed that I press CTRL + C more than once, even if I know that the file has been copied to the clipboard. But I press CTRL + X or CTRL + V only once.   Why do I do this? Is this only a problem for me, or is anybody else is facing it too? I'm having some trouble understanding a proof on  on Number Theory and I was wondering if you guys could give me some help. The problem is that I don't understand the last implication on the proof for example 1.1     Example 1.1. Let x and y be integers. Prove that 2x + 3y is divisible by 17 iff 9x + 5y is divisible by 17.      Solution. 17 | (2x + 3y) ⇒ 17 | [13(2x + 3y)], or 17 | (26x + 39y) ⇒ 17 | (9x + 5y)       conversely, 17 | (9x + 5y) ⇒ 17 | [4(9x + 5y)], or 17 | (36x + 20y) ⇒ 17 | (2x + 3y).   My problem is that I don't understand how does 17 | (26x + 39y) imply 17 | (9x + 5y). If you could elaborate on this step I would be most grateful.  I'm sorry if this is an obvious question but I am a beginner and I just can't get it.  Thanks for your help in advance. Why does `type which` say that `which is hashed`? How do I avoid checking for updates for a specific module? In a current project I have had to patch the life out of a few modules (node hierarchy, workbench access and a few more). These modules are now absolutely perfect for the project's needs and are very unlikely to break with future updates to core.  That being said, when the app is handed over the clients will have full (user 1) access to the system and will therefore be warned when these modules have available updates. And they will update them, no matter how many times I beg them not to (oh how easy life would be without clients!).  Is there a way (perhaps in the modules' .info files) to persuade the update manager not to check for updates for these modules?  EDIT  I'm aware of the project status url key that's available for the .info file so I guess I could set that to a non-existent URL but I'd much rather do this in a clean way if possible. Move object in inches instead of feet? Whenever I move an object in blender in unit mode(Imperial), it always make it in feet. For example, if I type G Y 12, it will move 12 feet. How can I make it move 12 inches instead? Where To start Learning With Salesforce Development How does a graduate program's admissions committee operate? How does a typical graduate program's admissions committee operate? (In the US --- I understand that in Europe admissions are often structured differently.)  My mental model at the moment is several professors sitting in a conference room with a stack of printed applications and a few piles: accept, maybe, and reject. Three or so professors will read an application and then make a decision. If the volume of applications is large enough, multiple meetings might be required. This is purely my imagination --- I don't know how accurate this model is.  Of course, I'm sure that how admissions are handled depends greatly on the school, program, and department. I'm interested in a few data points to get a rough idea of what the average is.  A few more specific related questions:   How much time does a typical committee spend on each application? I suspect there's a distribution. Obviously unqualified applicants will probably have their applications tossed into the reject pile pretty quickly. Qualified applicants' applications might receive more attention. Do admissions committees look online for more information about an applicant? I've read some professors (in CS --- not my field) will look at a student's research/project website, but I have no idea how common this is.