sql server - How can i use the sum of sums in a having clause in SQL -

This is my SQL code, problem is in the HAVING section, I have tried to use On the alias name, it will not work that someone told me that there is no facility to use the alias name in the HAVING section or WHERE section in SQL Server, so I Tried to use this one but it is not working, either

Please I need your help.

Here is my SQL code:

  SELECT LEFT (RSTab1.EventstartDate, 6) MONTHtab1, LEFT (RSTab2) Investment Date, 6) Mantat 2, RSTAB2, TIGMNumber (Subscriberbase). [DBO]. [CDRsbbbb@redge.org] With AS RSTAB1 (NOLKACK) ININ JOIN (SRTAB 2) Revenue RWF + SUM (RSTAB 1. Revenue) Total number of subscriptions from DRHUX1. RSTab1.Tig with DWHAUX1.CCDRNOrmal.dbo.nrmMSC RSTab2 (NOLOCK) OMainNumber = RSTab2.CalledPartyNumber where between 201310 and 201403 or left (RSTab2.EventstartDate, 6) between 201310 and 201403 and SUM (SUM (RSTAB 2.RevenueRWF) + SUM (RSTAB1 Revenue) between left (RSTab1.EventstartDate, 6) 6) Group by Left (RSTAB, Ententement Date, 6), Left (RSTAB 2. Avenantstant, 6), RSTAB 1. Tigo Mannambar Having SM (SM (RSTAB 2. RevenueRWF) + SM (RSTAB 1. Revenue )); COUNT (*) DES with order of 680 (SEST LEFT (RSTab1.EventstartDate, 6) from  
   
   

 











    





Popular posts from this blog




Java - Error: no suitable method found for add(int, java.lang.String) -






April 15, 2013








    I'm in the middle of homework work and I'm stuck. At this point in my code, I think that I should have a GUI window that opens and allows me to type "inserted text number". Notice is not going anywhere but at this point, If I pass through the problem then it will be in a linked list. I am getting two of the same error for the lines. Add (index, element); And I can not seem to get past it, there is no suitable method for the error "add (int, java. string string)". Code is below, please advise. To clarify - this will not be a method error because it is a linked list. There should not be any way involved.    import java.awt. *; Import java.awt.event. *; Import javax.swing. *; Import java.util. *; Import java.util.Scanner; Import java.util.LinkedList; Public class TopTenList JFrame {Private TopTenList tt; See the Private JTextArea list; Private JTextField cmdTextField; Private JTextField resultsTestfield; // This GUI window is the code for the public toptist...





Read more





java - JPA TypedQuery: Parameter value element did not match expected
type -






January 15, 2015








I am using JPA 2.0 and getting the following code in the DAO layer:    Public Zero Test () {string key = "status"; String [] Conditions = {"A", "B"}; & Lt; TestTable & gt; Results = Search (Keys, Conditions); } Public listing & lt; TestTable & gt; Search (string key, object value error) {string sql = "test ndf to testlet and jade nand." + Key + "in:" + key; TypedQuery & LT; TestTable & gt; Query = entityManager.createQuery (SQL, TestTable.class); Query.setParameter (key, Arrays.asList (valueArr)) / *** Error Line *** Return query.getResultList (); }    In the above error line, it throws the following exception:    java.lang.IllegalArgumentException: parameter value element [[Ljava.lang.String; @ cbe5bc] did not match the expected type [java.lang.String]    Why is this expected type string while actually this string []? Please help!   Note: This is derived from the normal routine and is a simplified code. I can no...





Read more





c++ - static template member variable has internal linkage but is not
defined -






March 15, 2013








    Yes, I know, there is a question with almost the same title, but it refers to a different situation. Error message) In my case, I have a  .cpp  file with a big named designation name (implementation details). There is a property class template with a static data member in that name space, which I need to access from outside the unknown namespace. I give it a little bit of meat:    file.hpp namespace Bar {template & lt; Typename A & gt; Struct foo {static_assert (is_same & lt; a, float & gt; :: value} is_same & lt; a, double>: value, ""); Fixed zero set_static_var (a const & x); // ...}; }    and    file.cpp namespace {template & lt; Typename A & gt; Struct foo_traits {// supports the implementation of several static code bars: foo & lt; & Gt; Fixed A data; }; The template's & lt; & Gt; Float foo_traits & lt; Float & gt; :: datum; // No change if this is in the global namespace template & lt; & Gt; Doub...





Read more














Powered by Blogger



Theme images by Michael Elkan























Unknown




Visit profile









Report Abuse







Archive











September 2015226


August 2015216


July 2015234


June 2015219


May 2015237


April 2015211


March 2015218


February 2015239


January 2015225


September 2014248






August 2014205


July 2014217


June 2014213


May 2014202


April 2014230


March 2014218


February 2014247


January 2014236


September 2013239


August 2013208


July 2013225


June 2013207


May 2013232


April 2013235


March 2013185


February 2013264


January 2013227


September 2012226


August 2012214


July 2012238


June 2012211


May 2012231


April 2012237


March 2012226


February 2012199


January 2012238


September 2011192


August 2011219


July 2011232


June 2011229


May 2011234


April 2011226


March 2011232


February 2011230


January 2011222


September 2010234


August 2010227


July 2010240


June 2010236


May 2010206


April 2010224


March 2010267


February 2010217


January 2010225



Show more
Show less