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 5840Hello 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 6916I 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 11488How 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 13567i was asked to journalise nominal accounts please give me the answer with examples so dat its easy for me 2 understand
3 3981when 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 22039what 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 64931) 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 6691Post New Target Interview Questions
Name Different Kinds of Debentures According to Redemption Point of View?
What are the advantages of python?
What are guards in laravel?
How to style the first line of a paragraph as a uppercase ?
What is the content of Exchange in camel?
How many section database vuser script have?
What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?what are differences between different versions of co-op?
Explain how to create dlq rules table?
What is #include stdio h?
What is the meaning of term weight initialization in neural networks?
What are the types of consensus algorithms?
what are the different cloud service models in cloud architecture?
kaise hum ek ias banna chahte hai
Where does TDS codes maintain and which fields are updated for TDS calculation for invoice/Advance
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration