Getting an Error because its Denominator Column has 0.
By: Sugandh | 12 May 2015 4:51 pm | 519 times viewed | 0 Comments
I need a help in sql query :while trying to divide two columns.
I am getting error because its denominator column has 0.
So how to handle this in sql query.
Please assist here, Thanks in advance.
No Comments Posted for this Article.
SAP Updates Failures Impact the Efforts of CompaniesUpgrading SAP processes is more often than not considered as a costly, time consuming and inefficient function for businesses, thereby leading to a scarcity in SAP updates. Over 33 percent of companies using the popular Oracle E-Business Suite have failed to upgrade their modules. 40...
SAP is Complex: Is there an Easier Way to Say This?Though the SAP software presents an extremely customer-friendly exterior, it remains enormously complex; wherein it needs millions of lines in code for effective functioning in a large enterprise. 'The lack of code quality is a pressing issue on SAP’s 100,000-plus...
SAP KANBAN Implementation ConsiderationsFor those of us who are not aware what the term, "Kanban" refers to, this is a process which is related to monitoring and regulating the flow of material and production which is primarily based on the quantity of the material stock in production. This is the quantifiable stock which is...
SAP Installation Hardware Requierment for SAP 4.7, ECC5, ECC6 IDES Non IDESSAP Installation Hardware/System RequirementsSAP 4.7 IDESHDD: 80 GBProcessor: PVI and aboveRAM: 512 MBSAP 4.7 NON IDESHDD: 80 GBProcessor: PVI and aboveRAM: 512 MBSAP ECC5 IDESHDD: 150 GBProcessor: PVI and aboveRAM: 2 GBSAP ECC5 NON IDESHDD: 150 GBProcessor: PVI and aboveRAM: 2 GBSAP ECC6 IDESHDD:...
Top 27 SAP BASIS Interview Questions and Answers for IBM1. What is private mode? When does user switch to user mode?Ans: Private mode is a mode where the heap data is getting exclusively allocated by the user and is no more shared across the system. This happens when your extended memory is exhausted.2. How can I restrict the user from printing? (What...
SQL Financial Accounting Error..
Hi all, I have one problem regarding the SQL financial accounting software.When i run this software,it display this message: Exception EAccessViolation in module SQLAcc.exe at 000041f1 Access...
Unable to Start SQL Server It Went Offline.
Hello Experts,I am unable to start SQL server it went offline I have checked all the things in configuration manager all the ports are enabled how to start the SQL server couldPlease help on this...
Why It is Asking for Bind Variable at Line 11?
Hello Experts,Please help me with this ref cursor scenario. why it is asking for bind variable at line 11 because when i put :depid instead of 20, the code is working fine.1 declare2 type emp_ref is...