Which are the different layers that define cloud architecture?
How will polarity test of Dy5 Transformer ?
How to get the Background color of a Tab or Button in TestComplete Tool using VBScript? I have a validation that to verify whether a particular tab or button is highlighted or not. When the tab or button is highlighted the background color will be in Yellow color.If i get the background color then its easy for us to validate whether its highlighted or not. Can anybody help me on this?. Thanks in Advance.
How do you relate JAVA and DOTNET with Application Support,Infrastructure Support Development in a Project Management Perspective
1. Fdr mature with interest
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
Anyone have any idea when to conduct Uniformity of Weight (UOW) and when need to conduct Uniformity of Dosage Units (UOD) or when need both? I read BP it only said if average weight < or = 0.04g then just conduct UOD, no need UOW. Under UOD section, it doesnt say when need to conduct UOD but just said UOD got two type, one is Mass Variation (MV), another is Content Uniformity (CU) and under what conditions to conduct them. For USP, no UOW section, only got UOD section.
vat on liquor vat on food ? vat on bevrages ? vat on tobaco? vat on gold?
What is the system approach to management? Explain the salient features of this approach? Describe various managerial skills briefly. Discuss the roles these skills could play in building an institution? Discuss the roles these skills could play in building an institution
can any one please tell me QTP 9.2 supports which version of IE and Mozilla firefox.
Which type of DG need Netral Earthing?
What is difference between AHX AND AH when referred to Withdrawal sleeves ?. Can we use AHX withdrawal sleeve with CK bearings ?
sir, pls send me 5 year previous question papers of RRB- Junior Engineer-GrII to my mail id
RR masonry rate analysis
Hi.. I am a BE GRaduate in E&E. I have 8.5 Experience in Tendering & Estimation field. I have done SAP SD course few years back. But due to some reason i failed to get job in that field and continued my own field. Now I am thinking of changing into SAP seriously. How should i go ahead???