I am using following query to extract appointment data:  SELECT app.subject, AL.locationName FROM FilteredAppointment app INNER JOIN appointmentlocation AL ON app.activityid = AL.appointment WHERE app.scheduledstart='2013-07-06 15:00:00.000'   The output is as follows with 2 rows (same appointment with two different locations):    How can i modify this query to display only one row with two locations concatenated with comma like below:  Column1: (MZN; OTV)*... Column2: Room1,Room2  Thanks
How do I get:  id       Name       Value 1          A          4 1          B          8 2          C          9   to  id          Column 1          A:4, B:8 2          C:9
Disable the default app key (super+num) functionality on Ubuntu 17.10 and later I like to switch workspaces via Super+Number. But unfortunately the default behavior in Ubuntu for Super+Number is to select applications from the dock.   Is it possible to disable that functionality? I've tried overriding the keyboard shortcuts but it doesn't appear to be working. Removing a list of characters in string Convert Month Number to Month Name Function in SQL Why don't Death Eaters always use Avada Kedavra? When the Death Eaters attacked Hogwarts, why did the Death Eaters not just use Avada Kedavra and kill everyone? TeXLive Pretest 2018: beamer and subfig collide \documentclass{beamer}  \usepackage{subfig}  \begin{document}  test  \end{document}   returns undefined control sequence \@@magyar@captionfix  (It was not so in January; I am on fully updated pretest) I want to do:  int a = 255;  cout &lt;&lt; a;   and have it show FF in the output, how would I do this? Per User Named Credential and External Identity Users My question is almost similar to one mentioned in 'Auth Provider with per-user Named Credential' (). I am trying to authenticate and make a API call when a new or existing Salesforce community users try to log in. The Authentication is provided by 3rd party (Cognito). So, the requirement is :  User to be authenticated using the 3rd party system for login. After successful authentication and before community page is displayed, the API call is to be made to 3rd party system to get more details about the user.  In order to achieve this:  Created an Open ID Connect Auth. Provider Use the registration handler on the Auth. Provider to create/link a new/existing user. Use a login flow for API call. Use Per User Identity Type Named Credential to make API calls.  No, where I am having issue is once the user has authenticated successfully, how do I allow the user to make API call without authenticating it again. I am getting the error: An Apex error occurred: System.UnexpectedException: You don't have permission to view this data, enter credentials for the named credential in your personal settings. Or ask your Salesforce admin for help. I believe this error is due to the fact that the user is not listed under 'Authentication setting for External Systems'. My requirement doesn't allow me to authenticate the user again, so how do I achieve this using either APEX or any other way? Four tasks in parallel... how do I do that? I have a bunch of PNG images on a directory. I have an application called pngout that I run to compress these images. This application is called by a script I did. The problem is that this script does one at a time, something like this:  FILES=(./*.png) for f in  "${FILES[@]}" do         echo "Processing $f file..."         # take action on each file. $f store current file name         ./pngout -s0 $f R${f/\.\//} done   Processing just one file at a time, takes a lot of time. After running this app, I see that the CPU is just 10%. So I discovered that I can divide these files in 4 batches, put each batch in a directory and fire 4, from four terminal windows, four processes, so I have four instances of my script, at the same time, processing those images and the job takes 1/4 of the time.  The second problem is that I lost time dividing the images and batches and copying the script to four directories, open 4 terminal windows, bla bla...  How do that with one script, without having to divide anything?  I mean two things: first how do I from a bash script, fire a process to the background ? (just add &amp; to the end?) Second: how do I stop sending tasks to the background after sending the fourth tasks and put the script to wait until the tasks end? I mean, just sending a new task to the background as one tasks end, keeping always 4 tasks in parallel? if I do not do that the loop will fire zillions of tasks to the background and the CPU will clog. "Welcome to the Jones__": Plural or Plural Possessive? When making a welcome sign, what form of the name Jones would you use?  ("Welcome to the Jones__") What is the difference between N and N-1 in calculating population variance? I did not get the why there are N and N-1 while calculating population variance. When we use N and when we use N-1?      It says that when population is very big there is no difference between N and N-1 but it does not tell why is there N-1 at the beginning.  Edit: Please don't confuse with n and n-1 which are used in estimating.  Edit2: I'm not talking about population estimation. How to enclosure a text block into big square brackets? everybody.  I need to enclosure a text block into big square brackets.  Something like this (I need to replicate it, more or less):   I've read that it could be possible with tikz but I don't know anything about that package.  Even, I found a code that reproduce something similar but with braces in this post:  The code is this:  \documentclass{article} \usepackage{lipsum} \usepackage[many]{tcolorbox} \usetikzlibrary{decorations.pathreplacing}  \newtcolorbox{rightbrace}{%     enhanced jigsaw,      breakable, % allow page breaks     frame hidden, % hide the default frame     overlay={%         \draw [             fill=none, % fill paper             decoration={brace,amplitude=0.5em},             decorate,             ultra thick,             gray,         ]         % right line         (frame.north east)--(frame.south east);     },     % paragraph skips obeyed within tcolorbox     parbox=false, }  \begin{document}  \begin{itemize}     \item First line           \begin{rightbrace}             \item Second line              \item Third line, which is quite long and seemingly tedious in the extreme             \item Fourth line, which isn't as long as the third            \end{rightbrace}     \item Fifth line \end{itemize}  \begin{rightbrace}     \lipsum[1] \end{rightbrace} \lipsum[2]  \end{document}   How could I put the square brackets around a block of text? (Using tikz, tcolobox or whatever package then can be useful for it).  Thanks for your help. I am making a regex expression in which I only want to match wrong tags like: &lt;p&gt; *some text here, some other tags may be here as well but no ending 'p' tag* &lt;/p&gt;   &lt;P&gt;Affectionately Inscribed &lt;/P&gt;&lt;P&gt;TO &lt;/P&gt;&lt;P&gt;HENRY BULLAR, &lt;/P&gt;&lt;P&gt;(of the western circuit)&lt;P&gt;PREFACE&lt;/P&gt;   In the above same text I want to get the result as  &lt;P&gt;(of the western circuit)&lt;P&gt; and nothing else should be captured. I'm using this but its not working:  &lt;P&gt;[^\(&lt;/P&gt;\)]*&lt;P&gt;   Please help. Which is correct: "one or more is" or "one or more are"? How can we improve the inconsistent tagging of the questions relating to the recent uproar and associated issues? Question description  There are many questions (~250 in the last five weeks) relating to      sometimes they are about licensing, legal issues, , , , etc.  These questions relate to the same growing polarization between community and Stack&nbsp;Exchange staff. But, it is not easy to search or filter them because the tags are not uniform for those questions, they do not have the same tags.  Could we group all these posts together by some common tag (new or not)? (in addition, maybe we should create less of these questions, they tend to become noise now, water down the core message, and it is ).    Relevance  Overview of current tags (aside from the discussion tag) for the first ten  (           ) questions relating to  (ordered by relevance)                              1   2   3   4   5   6   7   8   9   10     moderators              x           x   x   x     community               x           x   x     etiquette                   x     users                       x     company                     x     moderation                      x     code-of-conduct                     x       x       x     deleted-questions                               x     legal                                                   x   These tags are obviously not the same while it is arguably the same topic (it is even for the same, specific, search term) .  Instead of using multiple searches one might wish to control tracking these question by adding some single relevant tag to watched tags or ignore tags. But, this is difficult when they do not use the same tag. And in the case of ignoring one might ignore too much when the tag is not specific.  Another indicator that these posts need consistent tagging is the fact that there exist highly upvoted answers that function as an archive for these questions (see  and ). But it is only a hack/workaround for the absence of a common tag; they are not an optimal solution.    Why now?  In an older question () it was suggested to create a specific tag. That was rejected at that point. But, now we are several weeks, and many many questions, further. The situation is more escalated than what might have foreseen at that point. The overview becomes a mess and something needs to be done.  See the bump in the image below which indicates that something is 'going on' and it entails a large fraction of the current post. (obtained from ) Using Joint Distributions and conditional probabilities This exercise is particularly confusing me because I do not understand the distribution of 'X-Y' or how to calculate the probabilities What kind of "mathematical object" are limits? How to use dependency injection for Plugins/Blocks [\Drupal::formbuilder() and \Drupal::config()]? What alternative notation of subscripts/superscripts that are also treated as SYMBOLS in Mathematica? WoeUSB Error Code 256 with NTFS formatted USB I tried to create a Windows 10 USB boot medium with WoeUSB. I formatted a USB drive with an NTFS partition, but WoeUSB complains with:  Installation failed! Exit code: 256 Log: WoeUSB v@@WOEUSB_VERSION@@ ============================== Mounting source filesystem... Error: File "/media/woeusb_source_1543626298_6098/sources/install.wim" in source image has exceed the FAT32 Filesystem 4GiB Single File Size Limitation and cannot be installed.  You must specify a different --target-filesystem. Refer: https://github.com/slacka/WoeUSB/wiki/Limitations#fat32-filesystem-4gib-single-file-size-limitation for more info. Unmounting and removing "/media/woeusb_source_1543626298_6098"... You may now safely detach the target device   I've also tried to start WoeUSB via command line, did not work.  sudo woeusb --partition Win10_1809Oct_English_x64.iso /dev/sdb   My iso is located in:     home/sawyer/Downloads/Win10_1809Oct_English_x64.iso  Thanks in advance! I've been trying to get windows installed for three nights now, so any help towards that goal is greatly appreciated. Are partially charged wands generally purchasable?