write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000
1 40331.In VB Script 100 lines Script. How can check the Syntax errors? 2. Write a VB Script for X = India/Srilanka/Australia/England/South Africa.I need the Output Country wise? [ 1st Msgbox India , 2nd Msgbox Srilanka] ---- 3. How can Choose these test cases to be automated?
5 6376How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?
3993Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
8 9350How is the 90 percentile calculated? Say I am having total 2000 transactions pumped to the system and I have 1800 passed and 200 failed. So the 90 pertile is considered from the Passed transactions or (passed+failed) transactions?
4 9507Post New HP Interview Questions
"In boiler, what does steam and smoke goes out to the funnel. What reason?"
In the servlet 2.4 specification singlethreadmodel has been deprecated, why?
What is orm in spring?
What is pin diode?
Describe the Stabilisation of Barium sulfate precipitate in McF' scale ?
Describe the advantage that uddi has over disco?
How to prepare for oracle pl sql certification?
Explain the use of extension manager in joomla.
How automation testing is different from manual testing?
What are the fetching strategies in hibernate?
What is partitioning in MapReduce?
How to write a program to show the function of action helper?
What are some factors that explain the success and recent rise of deep learning?
How many default number of shells available and what are their names?
What is openrowset sql server?