• select parent where more than one child

    I want to select a row from the parent table based on whether there are two or more rows in a child table. What is the best way to do that?

    Ghjazz5 pointsBadges:
  • sql query

    I have stored A value in a string , when I try to use the STRING VARIABLE IN SQL QUERY DOESN'T NOT RESPOND??

    Shyamthandra5 pointsBadges:
  • Get your FREE ITKnowledgeExchange.com sticker

    Be proud to show off you are part of the community with your free ITKnowledgeExchange.com sticker. All you have to do is answer a question and email me your handle and address and we will get one out in the mail to you. Allow 4-6 weeks delivery. Even if you have one already get one for your...

    ITKE352,470 pointsBadges:
  • How to call a shell script from ABAP program?

    This question is to SANDEEP KULKARNI. If he is still with this website then please respond to this question, if not, requesting other users to provide real time solution. Also, requesting this forum owner to pass the SANDEEP KULKARNI's email ID/contact number. Question is: I have a shell script...

    CallingscriptfromABAP15 pointsBadges:
  • Slow File sharing access in Win 98

    Actually I have 2 questions: I have a small workgroup of 3 XP Pro systems, 2 win98 systems, 1 win 2000 server and a 16 port ethernet switch(100mbps). I have enabled the ICS in the server and each compter can access files/printers and internet with the help of DHCP. 1) When I access the win98...

    BinooDas123410 pointsBadges:
  • Open IT Forum: Tell us your must-read IT blog or Twitter feed & earn 50 knowledge points!

    We're always looking for great resources to share with the community, so here's your chance to share what's in your own bag of tricks! Share your favorite IT blogs or Twitter personalities, what they write about, or a link to a post that taught you something you'll never forget. Don't have a...

    MelanieYarbrough6,345 pointsBadges:
  • Create “if then” formula in Access 2003

    Hello, I'm new with access. I have a table with article numbers in one column. and intro and outro dates in 6 columns. the intro and outro dates come from 3 tables, so that's why the 6 columns (2 columns per table) However, I would like to combine the six columns into 2 columns, one for intro and...

    Jos197215 pointsBadges:
  • Data type for output file in DB2 SQL

    I am using DB2 SQL on the mainframe - not sure of the version - I want to write out a file and transfer it down to the PC - how do I specifiy numeric values for dollar values so that when I bring the file into Microsoft Access the numeric fields come in as numeric and not character?

    Kath95675 pointsBadges:
  • Tracking the computer or source of an email

    system: Ex 2003 back-end cluster, Ex 2003 Network Load Balanced Front end. Hi there, A user's account has become comprimised. They have since changed their password, but there are a few mails sent from their account that they did not send. Is it possible to find out the source ie PC hostname or IP...

    Maclanachu0 pointsBadges:
  • Link SQL Server 2008 to AS400

    How to set up a ODBC for SQL 2008 to the AS400

    Jaymz69765 pointsBadges:
  • Creating ACLs on the network

    How can we create ACLs on the network to block out users from attempting to connect to HR file shares?

    Troubleshooter24755 pointsBadges:
  • String Aggregate Function

    I need a report that provides an aggregate of a string column - in this case a concatenation of the values in a comma separated string. There is no such DB2 aggregate function that does this. A stored procedure (or possibly a customer aggregate function?) seems the only likely way to accomplish...

    Mgemmill5 pointsBadges:
  • Virtualize SCO OpenServer 5.0.6

    Hi, [span title="Clique para obter traduções alternativas" class="hps">I [span title="Clique para obter traduções alternativas" class="hps">recently inherited an old machine with [span title="Clique para obter traduções alternativas" class="hps">SCO OpenServer [span title="Clique para obter...

    saturno4,585 pointsBadges:
  • Cumulative totals in Access 2003

    I need to be able to calculate cumulative totals on groups of data in a query. Specifically I have a list of repair order numbers with associated part numbers required, dates the order was placed and the amount of the part needed for the repair. I need to be able to calculate a running cumulative...

    Acmaintainer20 pointsBadges:
  • Open IT Forum: What are your views on social networking platforms in your network?

    I chatted with David Sacks, CEO of Yammer, last week at Enterprise 2.0, and we talked about IT's changing attitude toward cloud-based offerings such as social networking platforms. I'd love to hear from practicing IT professionals about the impact of these platforms on the network, whether it's...

    MelanieYarbrough6,345 pointsBadges:
  • I need to know what components I will need to establish a hugh LAN and WAN Network

    Starting from scratch, I plan to have 600 users with e-mail, file and print, and Internet services. I will also have 10 servers used as LAN, proxy, and database servers. Two departments will need sufficient bandwidth and access applications from an Oracle server. We are also going to expand to four...

    ITBeginner10 pointsBadges:
  • COBOL/400, DB2/400

    Hi Group, I have a Physical file. It has 3 members, memb1, memb2 and memb3. In my cobol/400 program i need to access all the 3 members and put data into them. What is the select statement for the multimember PF? How to declare the file section for multi member PF? The  COBOL/40o pgm should be...

    mvrkrishna555 pointsBadges:
  • Getting error when i am trying to insert the record in QTEMP file trough QSH DB2 command

    i am trying to insert the record in QTEMP file trough QSH DB2 command but getting an error that file not found in QTEMP eventhough file is available in QTEMP. if i am giving my local libary instead of QTEMP then its working perfectly.

    Mdshadabalam85 pointsBadges:
  • Access 2007 Query Help

    I need some type of statement that will check my query results for a number in a field and then remove any instance of this item from my query. Example: I have multiple books in a table and I have an identifier field (1 = English, 2 = History, 3 = Science, etc...) where it can cause one book to...

    ThisGuy5 pointsBadges:
  • How to connect Access database to a Visual Studio 2005?

    i use the following code to connect and i created DSN but its not getting connected... whats my fault can anyone help me?? Dim X As ADODB.Connection Dim RS As ADODB.Recordset Dim RS1 As ADODB.Recordset i am getting underlined error in adodb.connection, adodb.recordset i think there is some error in...

    Rajeshbnp20005 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following