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
Suneel Reddy
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
Briefly describe your ideal job?
Why did you choose this career?
What goals do you have in your career?
How do you plan to achieve these goals?
Can you work well under deadlines or pressure?
Tell us about a time when you failed to meet a deadline.
What were
the repercussions?
Why do you want to work here?
Why should we hire you over the others waiting to be
interviewed?
What three Specific Job Positions do you target from the
Company?
Fedility Bank Lifestyle Isoft Abc . WHAT THREE (3) SPECIFIC JOB POSITIONS DO YOU OR DESIRE TO BE EMPLOYED IN THE TEXACO'S EXPANSION OF THE CAPTAIN FIELD OIL PROJECT SCOTLAND
in retail bussiness if we want the first and last visit of
the customer and the total purchase amount of the
customer.then what's the syntax in proc report.
whats is the difference between the proc tabulate and proc
report?i want the major difference which will effect?
To Refer this Site to Your Friends 
Site Map