SELECTSUM(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
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.
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
ehsanie4it
Member
64 Points
113 Posts
Re: this query doesnt work
Jul 25, 2012 07:36 AM|LINK
--if it it helpful remember check as helpful
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.
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.
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 :
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.