SQL Server group by count eliminate duplicates
How to use GROUP BY to concatenate strings in SQL Server?
System.CalloutException: You have uncommitted work pending I have same exception can please   The previous post issue is resolved.  Exception: :System.CalloutException: You have uncommitted work pending. Please commit or rollback before calling out  Visualforce Page   &lt;apex:page controller="Controller" action="{!init}" showHeader="false" sidebar="false"&gt;     &lt;center&gt;         &lt;apex:pageBlock title="Request Listener"&gt;&lt;/apex:pageBlock&gt;               &lt;/center&gt; &lt;/apex:page&gt;   Controller :            PUBLIC with sharing class Controller {        PUBLIC String fromNumber      = ApexPages.currentPage().getParameters().get('From');     PUBLIC String toNumber        = ApexPages.currentPage().getParameters().get('To');     PUBLIC String body            = ApexPages.currentPage().getParameters().get('Body');        PUBLIC PageReference init()     {                    System.debug('From Phone Number :' +fromNumber);         System.debug('To phone NUmber :' + toNumber);         System.debug('Message Body :' + body);          TwilioRestClient Client = TwilioAPI.getDefaultClient();                                                                SYSTEM.DEBUG('FROM AND To  Number is NOT NULL');                      String formattedNumber='+919876543210';                 IF(body != NULL)                 body = body;             ELSE                 body = '';             Case c = NEW Case (Subject = formattedNumber,Description = body,Origin = 'Phone');             INSERT c;                               Map&lt;String,String&gt; params1 = new Map&lt;String,String&gt;             {                'To'   =&gt; fromNumber,                'From' =&gt; '+1908280****',                'Body' =&gt; 'Conformation to customer'             };             TwilioMessage message = client.getAccount().getMessages().create(params1); /* Valid conformation SMS sent to the Customer.*/                                            return null ;     } }   While loin as admin then click preview on visualforce page executed but case is not created.I have checked the the debug log it throw the exception. In the sentence      It's one of the best films that has/have ever been made   What should the verb agreement be? We have to prove that  "the product of two numbers ending in 6 also ends with 6" mathematically.  I have no clue how to start. I don't want you to prove it for me! but some hints would be very helpful as I'm totally stuck on how to start this prove. proper usage of didn't had or didnt have MySQL GUI Tools 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) Align  elements side by side How can I count unique selections from multiple selections in a drop down list (Excel) I would like to count the number of unique selections from a column that contains multiple selections from a drop down list.  For example, column B3 contains,     Monday, Tuesday, Wednesday   The count function returns a value of 1 instead of 3 - is there any way to count the three days distinctly? Thank you!  Multiple selections from a drop down list was made possible using the VBA code from: I want to disable Bluetooth on my laptop running Windows 10 Pro x64, but I have a problem: the option to do so is missing even though I know that it was previously available.  Here is the Bluetooth settings pages should look like on Windows 10:    Here is how it looks for me:    As you can see, I am missing the switch to turn it on or off? Why is it missing? I know that just yesterday, it was available and I turned it off. What can I do to fix it? Where did the "wheel" group get its name? The wheel group on *nix computers typically refers to the group with some sort of root-like access. I've heard that on some *nixes it's the group of users with the right to run su, but on Linux that seems to be anyone (although you need the root password, naturally). On Linux distributions I've used it seems to be the group that by default has the right to use sudo; there's an entry in sudoers for them:  %wheel ALL=(ALL) ALL     But that's all tangential; my actual question is: Why is this group called wheel? I've heard miscellaneous explanations for it before, but don't know if any of them are correct. Does anyone know the actual history of the term? Delaunay triangulation to generate abstract networks and nodes Adverb sentence query He is arguably the best actor of his generation   In the above sentence the adverb is placed just after "be" Can we use adverb after "be"? If we can use then please explain properly because I have studied that adverb can be used before adjective and adverb . Power supplies are available in a wide range of voltage and current ratings.  If I have a device that has specific voltage and current ratings, how do those relate to the power ratings I need to specify?  What if I don't know the device's specs, but am replacing a previous power supply with particular ratings?  Is it OK to go lower voltage, or should it always be higher?  What about current?  I don't want a 10 A supply to damage my 1 A device. Ubuntu copy dialogue stops at the last moment for a long time Whenever I try and copy a file to an USB flash disk, the progress bar runs till the end very fast and stops for an indeterminable time before it is complete.  Is there an issue with ubuntu or my flash disk is what I am not able to figure out. All I want is a realistic copy dialogue I have a Canon 7D, which has a crop factor of 1.6x.  When using a Canon EF-S lens I get the focal length stated on the lens, when using a Canon EF lens I get the focal length times 1.6 when used on the APS-C body. At least that's what I thought.  I just compared two lenses:   Canon EF-S 15-85mm f3.5-5.6 Canon EF 70-200mm f4   .  The top photo is shot with the 15-85, the bottom photo with the 70-200 - both lenses are set to 70mm. Now why do they look the same?  I thought I would get 112-320mm (70mm*1.6 crop factor). What did I misunderstand about the crop factor calculation? Lightroom also displays the photos as having "70mm" and not 112mm. Importing 3D DXF file into QGIS with z information as attribute value? How do I access folders created on Ubuntu with Windows? I've been trying to photograph lightning lately, as we have had some great storms in Colorado. I've had some difficulty getting a good vantage point, however, as almost all of these storms include rain as well. To keep my camera from getting drenched (I have weather-sealed lenses, but my camera body, a Canon 450D, is not weather sealed as far as I can tell), I've had to shoot under the eve of a building or under a thick canopy of trees, however that has greatly limited my ability to adapt to the changing weather and get get a vantage point on the best lightning.  Is there any equipment, something I can purchase or something home-made that has easy-to-find parts, that can help me protect my lens from the rain while still being able to shoot? Additionally, I've been getting rain on a UV filter I have on the front of my lenses, simply to prevent rain from getting on the front lens element itself. However, once a storm really gets going, so does the rain. Is there a simple solution to keep rain off the front of the lens? Migrate database from Postgres to MySQL "You must wear a suit TO an interview" vs "You must wear a suit FOR an interview" In the sentence-     You must wear a suit to an interview   shouldn't the to be replaced by for? Or what's the difference between these two here?