Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance
5 7367Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy
6 8491I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can i do it and drag it onto report editor.
6 13461How we can code in a jcl to execute a job in a particular time and date without using any job shudular?. (Eg) i want to execute a particular job at 8 am on 01/01/2010.
2 14695i was asked to journalise nominal accounts please give me the answer with examples so dat its easy for me 2 understand
3 5599when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....
4 23611what is the drawback of vsam dataset?? a.execution slow. b.free space. c.independent storage device. d.none of the above. let me know the answer with reason.
4 80241) I have 5000 test cases within 3 working days u have to finish? How you will handle it. 2) Difference between Relase-1 and Relase-2
1 7410Post New Target Interview Questions
Where we use data driver in qtp?
How to calculate knee point voltage? Describe its purpose for differential protection.
What is the difference between web role and worker role?
What is jms connection factory in weblogic?
Why is it necessary that file needs to be opened in I-O mode for REWRITE?
speak about mumbai for 5 min
How to use subqueries with the in operators in ms sql server?
What is update method called?
What is war file in tomcat?
What is a tab in excel?
What is the ul tag?
What is raiseerror? What is raiseerror?
How splunk avoids duplicate indexing of logs?
How do I run flex as a service?
hello! sir i did three year of diploma in electrical (2007- 2010) and now i m a student of electrical engineering. sir can i apply for germany visa for study and part tome work over there?