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 7389Hello 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 8515I 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 13489How 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 14706i was asked to journalise nominal accounts please give me the answer with examples so dat its easy for me 2 understand
3 5616when 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 23621what 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 80411) 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 7419Post New Target Interview Questions
What are different types of raid configurations? : SQL Server Architecture
How do you view an xml file?
What is umask in unix?
WHAT ARE THE STEPS INVOLVED WHILE DATA UP LODGING IN LSMW
What are the categories of Dimension?
What is correlation in context of biztalk server? : biztalk server
What is stored in a test frame?
What is the difference between a server and a computer?
How can multi-hop agent be set up in Flume?
Explain what are enzymes?
How do you ensure that your models are fair and unbiased?
what happend to DC shunt motor if its field winding insulation becomes slightly weak? will that motor can run on full load or not explain in detail. thanks
What are the advantages and disadvantages of the dc motors?
what kernel is used in android?
what is the last date of deposit TDS on liability for the assessment year 2010-11