this query doesnt work RSS

• • Reply
  

  asifbhura

  Member

  169 Points

  175 Posts

  this query doesnt work

  Jul 25, 2012 07:15 AM|LINK

  SELECT SUM(EXCELLENT) as EXCELLENT,SUM(VERYGOOD) as VERYGOOD,SUM(GOOD) as GOOD,SUM(POOR) as POOR, SUM(VERYPOOR) as VERYPOOR FROM V_ATT_GUAGE_CHART WHERE DEPARTMENT_CODE='0201135'

  I have kept this query under try catch

  but it doesnt work, even it doesnt move to catch block

  i tried it in oracle, it is working.

  regards

  • Edited by asifbhura on Jul 25, 2012 07:16 AM
• • Reply
  

  ehsanie4it

  Member

  64 Points

  113 Posts

  Re: this query doesnt work

  Jul 25, 2012 07:36 AM|LINK

  Hi.
  
  
  I think it is because you have omited Group By after using aggravative function, so try this , and add it at end of your statement.

  group by EXCELLENT,VERYGOOD ,GOOD ,POOR,VERYPOOR 

  
  --if it it helpful remember check as helpful

• • Reply
  

  asifbhura

  Member

  169 Points

  175 Posts

  Re: this query doesnt work

  Jul 25, 2012 09:51 AM|LINK

  still same,

  It takes  2 sec in toad to execute,

  But through .net it goes on and on never ends,

  the interesting thing is that, it happens only with this view, if i would execute any other view or tables  from same schema

  It executtes in less than a seconds.

  • Edited by asifbhura on Jul 25, 2012 09:51 AM
• • Reply
  

  ehsanie4it

  Member

  64 Points

  113 Posts

  Re: this query doesnt work

  Jul 26, 2012 04:17 AM|LINK

  can you send your Field names , and also the error which appear after execution.

   

• • Reply
  

  ehsanie4it

  Member

  64 Points

  113 Posts

  Re: this query doesnt work

  Jul 26, 2012 04:31 AM|LINK

  Hi.  I think you should write your code like this :

   

  SELECT SUM(EXCELLENT) as EXCELLENT,SUM(VERYGOOD) as VERYGOOD,SUM(GOOD) as GOOD,SUM(POOR) as POOR, SUM(VERYPOOR) as VERYPOOR FROM V_ATT_GUAGE_CHART
  group by EXCELLENT,VERYGOOD,GOOD,POOR,VERYPOOR,DEPARTMENT_CODE
   WHERE DEPARTMENT_CODE='0201135'

  ==remember if it is helpful please vote as helpful.

  Thanks

• • Reply
  

  Ajay2707

  Contributor

  4477 Points

  865 Posts

  Re: this query doesnt work

  Jul 31, 2012 10:20 AM|LINK

  Hi Asifbhura,

  I am not clear about your problem. I think you run this query by an stored procedure and it not give response.

  if yes, then you can use pl/sql tool to test your stored procedure by file menu -> new -> test window.

  give there parameter value and check it. Also you check your execution path.

  I think this help . Still you have prob. then paste your query and .net code whichever give problem.

  Please, Mark as Answer if this reply helped you.