Please help me understand this query

Home Answers Viewqa SQL Please help me understand this query

Jubin

Please help me understand this query
0 Answer(s) a year and 5 months ago
Posted in : SQL

Hi,

Could someone please help me understand the following query. Im finding difficulty relating it :-( Pls Help!

select * from cbpartner where CBPartner.IsSummary='N' and salesrep_id in
(select distinct(aduserid) from aduserroles where aduserid=1000005 and adroleid = 1000005)
and isCustomer='Y' or ((salesrepid is not null or salesrepid is null) and Exists (select 'true' from aduserroles where adroleid != 1000005 and adroleid =1000002 and aduserid =1000005))

Thanks,

View Answers

Please help me understand this query
Please help me understand this query Hi, Could someone please help me understand the following query. Im finding difficulty relating it :-( Pls Help! select * from cbpartner where CBPartner.IsSummary='N' and salesrep_id

Please help me.
Please help me. Hi i am trinath in below there is a url.In that url there is a code of edit a jsp page.I understand that code but only one thing i not get it i.e; What is the work of "id".and what is the data type of id? http

Please help me??
Please help me?? Question_1: Using one-dimension array of primitive type elements. Objective: The purpose of this lab exercise is to practice how...: Using Collection Framework Objective: To understand the use of List interface

urgent...pleAse help me.....please!
urgent...pleAse help me.....please! please help me urgent! how can i do dictionary with the use of array code in java, where i will type the word then the corresponding meaning for that word will appear...thanks

please help me.
please help me. Please send me a code of template in opencms and its procedure.so i can implement the code. Thanks trinath

please help me.
please help me. How to read a properties file in java with a suitable example. Please send me. Thanks Trinath Please visit the following link: Java read properties file

please help me.
please help me. Please send me the validation of this below link. the link is http://www.roseindia.net/answers/viewqa/JSP-Servlet/9584-JSP-Servlet-Search-and-Edit.html Thanks Trinath

please help me.
please help me. How to move the edits.jsp in below link? http://www.roseindia.net/answers/viewqa/JSP-Servlet/9584-JSP-Servlet-Search-and-Edit.html

please help me.
please help me. I have a jsp page under that i add a list box under i get the countries through my database. so how can i do

help me please
help me please Hello I want helping for this question , Please Write a program that reads some friendsÃ¢â?¬â?¢ names, stores them in an array, and then prints out on the screen all friends who start by a particular letter

please help me
before. This name list should get from the database. Please help me. By the way, I'm...please help me Dear sir, I have a problem. How to write JSP coding, if a user select a value from drop down list for example department, the another

please help me.
please help me. I have three table in mysql,and i hava create a excel sheet and add this sheet.but my question is in every sheet i can display one one table result.how can i do

please help me...
please help me... write an application that print number in the following order using a FOR-Loop 1 2 3 4 5 2 4 6 8 10 3 6 9 1215 4 8 121620 5 10152025

please help me to this problem..
please help me to this problem.. i wrote a program like keyboard... inside the JTextField) but i want to make this program to let me write where i clicked (i.e allows me to write any thing at the field where i clicked

Please help me
Please help me program for when a user enter his card number, it has to create default security pin in the database

please help me
please help me interface Test1 { String toString(); } public class Test { public static void main(String[] args) { System.out.println(new Test1() { public String toString() { return "test

help me please
help me please how can i do dictionary with the use of array code in java, where i will type the word then the corresponding meaning for that word will appear...thanks

Please help me urgent...........
Please help me urgent........... For what kind of a problem would use a Tree Set and not a Tree Map For what kind of a problem would use a Tree Map and not a Tree Set Hello Friend, If you want to display the list

Please help me
Please help me Hi Sir, please send me the code for the following progrems... 1) all sets are integer type: input: set1={10,20,30,40} set2={15,25,35} output: union={10,15,20,25,30,35,40} 2) input: "Hi what

please help me?
please help me? Define a class named Circle with the following properties: List item An integer data field named radius with protected access modifier, and a String data field named colour with private access modifier. Both

please help me here
please help me here please show me how can this show the right output that i need please continue doing this program using only if else and do while please please" here is the problem Automatic Teller Machine [B] Balance [D

Query
original values but when i called second time it shows previous value. please help me for example if i have given k=9 for first life cycle the output also 9 but during second life cycle i have given k=18 it shows output as 9 answer me

Please help me to learn - WebSevices
Please help me to learn Please help me to learn Java Fast

query
query Sir this is table code. i created successfully ,but i want to get table data.so could you please help me for this problem.Thank you sir import java.util.*; import java.awt.*; import javax.swing.*; import

please help me to overcome this problem
please help me to overcome this problem how to make it easy to write java code. can u please give me suggestions

HQL Statement: Please help me
= Product.productGroupVersionId and Product.lobId = ? Can you please help me equallent HQL...HQL Statement: Please help me Select ProductFamily.* from ProductFamily, ProductGroup, Product where ProductFamily.productFamilyVersionId

Help me please!!! - Java Beginners
Help me please!!! im badly needing the complete code for this project in java!!! can you please help me???!!! it is about 1-dimensional array... the answers 8Hours from now!!! Kindly help me!! please!!please!!! NOTE

need help...................please
on this area. Please help me. By the way, I'm using access Database and JSP coding...need help...................please I have a problem in my JSP Coding...("GET",url,true) xmlHttp.send(null) } else{ alert("Please Select Employee Id

would you please help me?
would you please help me? Write a class Amount which stores sums of money given in pounds and pence. Your con- structor should take two ints, for pounds and pence seperately. The class should also provide methods to add

please help me - Java Beginners
please help me I have some error in this programe //write acomputer programe using java to generate following series : //output: //1,2,3,0,-2,7,-4..... class Series1HW { public static void main(String args

please help
please help please send me the code of dynamic stack in java without using the built in functions

java please please help
java please please help Dear Friends plz help me to complete...[] to HashMap so that i can seperate key and value using Map.Entry.Please help me! ... = map.entrySet(); Iterator it = set.iterator(); while(it.hasNext()) { Map.Entry me

help please
thing i want to imp in my app.please any one have app of this imp pls send me war file.. Or atleast help me with code here.. I tried checking session alive...help please hi i am done with register application using jsps

Please convert this SQL query to hibernate - Hibernate
Please convert this SQL query to hibernate I have a SQl query, which needs to be converted to HQL query, but i am not successfull, please help me..._in is null OR b.opted_in = 1) GROUP BY b.msisdn, a.msisdn Please, thanks

help me
help me please send me the java code to count the number of similar words in given string and replace that word with new one

help me
help me HI. Please help me for doing project. i want to send control from one jsp page to 2 jsp pages... is it possible? if possible how to do

help me
help me MY GLASSFISH SERVER NOT START PROPERLY help me warning shows DPL5404:Specification-Version for the optional package... ] is not specified. Please provide a valid specification version

Please help me... its very urgent
Please help me... its very urgent Please send me a java code to check whether INNODB is installed in mysql... If it is there, then we need to calculate the number of disks used by mysql

help me
help me hi sir pls tell me how to use ajax form validatin from very simple way with two ot three text field pls help me use ajax in php my email id... or send me some information for validation in ajax Hi Friend, Please

help me
button, and nationality I'm using dropdown list. Please help me. your kindness...help me Hi I'm loges. I'm doing my final year project now, I have some problem in my project and i need some help on it. NowI'm doing a site

Help me please with my final homework
Help me please with my final homework Write a Java program of your choice that demonstrates the following concepts: ? Input and Output. ? Selection/Conditional (e.g. if statement). ? Arithmetic. ? Loops. ? Arrays

please help me to write a code for this program
please help me to write a code for this program 1 1 1 1 2 2 1 1 3 4 3 1 1 4 7 7 4 1

please help me to write a code for this program
please help me to write a code for this program 1 1 1 1 2 1 1 3 3 1 1 4 6 4 1

please help me to give code - Java Beginners
please help me to give code Write a function with a signature cheerlead(word) that prints a typical cheer as follows. The word robot: Gimme an R Gimme an O Gimme a B Gimme an O Gimme a T What did you give me? ROBOT

please help me to give code - Java Beginners
please help me to give code Write a function, sliding(word, num)that behaves as follows. It should print out each slice of the original word having length num, aligned vertically as shown below. A call to sliding(examples, 4

help me
the order, Fourth button is Find length of text. and there are panels. Please help me. i want to write the code on this program. please share ur idea. ...help me Dear sir/medam i would like to know how to use the java

problem in writing coding. Please help me.
problem in writing coding. Please help me. Hi sir, my name is Logeswaran. I have problem in writing JSP coding for my university assigments... like? I'm really stuck on this. Please help me. By the way, I'm using Access

Please help me about maven2 plugin - Maven
Please help me about maven2 plugin First, thanks you for your all... an error. I send you the image i capture the error Please help me... maven plugin. When i go to help/software update/ find and install/ search

its very urgent please help me
its very urgent please help me how can i retrieve all images from ms access database and display in jsp pages

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.

Tutorial Topics