What all is needed to achieve an crystal report? A crystal report server ,User Id .Is BI/BO needed.Our source is Microsoft SQL Server 2008 Datacenter.Please guide.1364
How do you take challenges?
What are the benefits/risks when company traditional and genetically engineered breeding?
1. What is differential relay? How it operates? 2.How to calculate the Short Circuit Impedance in Transformer? 3.What is the alternate solution for testing of polarity by using polarity tester while its milli ammeter does not works? 4. While testing the 33KV Busbar by using Hipot kit, what should be the test voltage we have to apply? 5. What is the procedure/activities to be taken to inject the current more than 2000A by using 2000A Loading Transformer? 6. Explain how you can give the overload setting to any Motor Protection Relay for a HT motors with formula and example? 7. Why restricted earth fault protection is needed? Why can’t differential Protection is sufficient? 8. What should be the minimum and maximum ohmic value for earthing? 9. Why DC Currents are not used in transformer? 10. What is the Frequency while we step up the voltage from 220V to 11KV? Is it possible? Explain it?
What is the concept of Virtual field?
What are the renewal types?
How to close the CD Tray in code?
At 50 Centigrade (Diesel oil) what is its cast?
1.How can data be developed on Microsoft excel 2. what is the importance of Microsoft Excel to the society
How to calculate rental exemption if HRA is not given seperately and what will be the maximum allowability and under which Section of Income tax
How the Customizing of the VisiBroker ORB with interceptors and object wrappers?
1.Enlist the types of testing performed for any window in sequence? 2.Use of edit_get_list function 3.Accuracy & Precision
How does elaborating software requirements lead to inconsisteencies!
Why do we apply both Differential and REF (HV and LV) protection schemes on YNyn configuration of a transformer?
Hi, I am new in oracle(SQL), could anyone help me in writing a correct SQL. Below is the table structure. Table: Subsc Fields: 1. Sub_no (this field will hold values of subscriber nos, for e.g. S111111, S222222, S333333, S444444, etc.) 2. s_status (this field will hold values for different status of subscriber, for e.g. 'A', 'S', 'C', etc.) 3. cus_id (this field will hold values of bill nos for e.g. 11111111, 22222222, 33333333, 44444444, etc.) Table: Bill Fields: 1. Bill_no this field will hold values of bill nos for e.g. 11111111, 22222222, 33333333, 44444444, etc.) 2. b_status = (this field will hold values for different status of bill for e.g. 'O', 'C', 'S', etc.) Note: 1. The Sub_no is a Primary key of Subsc table. 2. The cus_id is a foreign in Subsc table (referred from Bill_no field of Bill table) 3. The Bill_no field is the Primary key of Bill table. Query A --> I wrote a query to select cus_id/Bill_no which is in status open (b_status = 'O') and having more than two active subscriber (i.e. S_status = 'A') in it ( i.e. more the two subscribers in same bill). select s.cus_id from subsc s where exists (select 1 from bill where bill_no = s.cus_id and b_status = 'O') and s_status = 'A' group by s.cus_id having count(sub_no) = 2 Problem : The above query will give the cus_id (or rather bill_no) which are in open status (b_status ='O) and which are having TWO ACTIVE Subscribers (s_status ='A') in it. However, this query will also lists the cus_id/bill_no which are having more than TWO subscribers in it (but only two subscriber will be in Active status (s_status = 'A') and the others will be in s_status = 'C' or s_status = 'S'. Help needed: I want to write a query which will fetch ONLY the cus_id/bill_no which are in open status (b_status ='O') and which are having ONLY TWO ACTIVE subscribers (s_status ='A') in it. B--> If I include the sub_no in the above query then NO row are returned. select s.cus_id, s.sub_no from subsc s where exists (select 1 from bill where bill_no = s.cus_id and b_status = 'O') and s_status = 'A' group by s.cus_id, s.sub_no having count(sub_no) = 2 Help needed: I want to modify the above query which will fetch ONLY the cus_id/bill_no which are in open status (b_status ='O') and which are having ONLY TWO ACTIVE subscribers (s_status ='A') in it ALONG with the sub_no. Thanks a lot in advance. Regards, Nitin
hi friend i have selected in ssc cgle as accountant in audit department. can anyone tell about the work of accountant in audit department?