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 7630Hello 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 8748I 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 13708How 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 14818i was asked to journalise nominal accounts please give me the answer with examples so dat its easy for me 2 understand
3 5710when 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 23762what 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 82041) 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 7474Post New Target Interview Questions
Can u tell me the principle of the tc,rtd,level switch,pressure switch ,transmitter(pr flow level temp.),vibration...plz
What two properties of electromagnetic waves are used to attach info to radio signals?
How to calculate Acctually Brickwork Quantity in Honey Comb Brick in circular Soak Pit
What is the synonym of framework?
Explain the difference between string, stringbuffer and stringbuilder in java?
How to mouse hover an element in selenium?
Give an example of one address microprocessor?
What are the different types of runners?
what is the effect on the instances of a symbol if the symbol itself is changed? : Adobe flash
how to work on CMA form in manufacturing compay as well as how to analysis working capital ?
after medical test,when will be the police verification
Why would you use conditional formatting in excel?
How will be the future for ruby on rails?
How do you run ms_batch file in forms?
Why does all cellular networks have same shape of sim?