• Debug

    How to debug an SQL Stored Procedure?

    bigT35 pointsBadges:
  • SQL SERVER

    The SQL Server mobile edition is supported on?

    siphesihle10 pointsBadges:
  • Complex sort for SQL Query?

    I have a table: MY_TABLE IDENTIFIER (VARCHAR) NAME (VARCHAR2) DATE (DATE) SELECT NAME, IDENTIFIER, DATE FROM MY_TABLE ORDER BY IDENTIFIER, DATE; So that works great for ordering the identifiers (basically making them look like a grouping in the output). Then sorting them by date (makes it sort...

    KGNickl50 pointsBadges:
  • Database

    How to create a database of prison management system using SQL?

    abuhafsah25 pointsBadges:
  • Oracle first or SQL

    Hello Everybody, I would like to learn Oracle. The question is: should I learn SQL before I start to learn Oracle? Why? Thankx Zaid

    Zaid198140 pointsBadges:
  • using SQL in RPG

    I want to use the following 2 SQL statements in 1 RPG program and have the results print out. How can i accomplish this task? Not sure how to do even 1 SQL statement and have it print, let alone 2. Select RNSREGN region, COUNT(RNSINVN) #Orders, SUM(RNSQTY) #Books, SUM(RNSTOT$) $$ from...

    rmb115 pointsBadges:
  • Link to file in IFS – file not found error.

    To avoid sending very large SQL results through the email system I have created a command to place the file in the IFS and just send a link to the user via email. When I click on the link to open the file, it opens right up. When the users click the link, they get a "file not found" message. Why? I...

    Jsuper25 pointsBadges:
  • Best Technology for learn

    i m the computer graduate doing job in technical support & wants to learn new technology can u suggest any new technology

    santosh1234567891030 pointsBadges:
  • need help with measuring dates

    I am trying to select records from a table where the CREATEDT field is between SYSDATE and 20 days prior. select distinct(createdt) from U_table where to_char(createdt, 'dd/mm/yyyy') between to_char(sysdate, 'dd/mm/yyyy') and to_char(sysdate - 20, 'dd/mm/yyyy') There are records in that table that...

    jkeri355 pointsBadges:
  • how to store the radio buttons checked value in a database (sql)using vb.net

    Iam having 2 radiobuttons in my web form rbown and rbrent for the user to selcet whether he owns a house or he rents.I assigned own and rent as text propertis to the 2 radiobuttons and groupname as group1. Iam trying to store the text values depending on the selection of the radiobuttons in the...

    Anupamak1515 pointsBadges:
  • Using Decode in oracle sql query for Debtors Analysis Report

    i have a table called transactions in my oracle database which stores data for employees under particular employers. each member has an account and employer_id with transactions , the table has fields as below. TRAN_ID, TRANTYPE_ID, PENSION_ACCOUNT, EMPLOYER_ID, TRANAMT, SALARY, TAXEDAMOUNT,...

    wiri5 pointsBadges:
  • SAP HRP 1000 & 1001

    Hi For a recent Datawarehouse building activity, we'r to pull data from one of the SAP HR System to our SQL Database. I'm not much familiar with SAP and hardly have any idea about SAP internal architecture and I need ur help thus. I was told HRP 1000 Has all the object details and HRP 1001...

    Mkiva5 pointsBadges:
  • Training- SCOOP Inc.

    I'm thinking of taking some training from SCOOP Inc. They offer iSeries training (Java, SQL, RPG etc.). Have any of you taken training from them? If so what did you think? Pros? Cons? Would you recommend them? Let me know. Thanks!

    Dantheband0 pointsBadges:
  • RE: SQL Restore Error (SQLSTATE 42000 “Internal Consistency Error”

    Hello All, I am in need of some advice. We recently had a database go down and become corrupted. When I went to restore I receive the following error (Title Bar: ODBC SQLSTATE42000, Message:Internal Consistency Error, contact technical assistance...... I did have this happen once a few months back...

    Wingis0 pointsBadges:
  • Transform rows to files in an SQL statement.

    Hello We hava been able to produce the SQL that returns us a Vertical table with the LABELTEXT  from table CLIENTES (sql against qsys2/syscolumns).   SELECT LABELTEXT FROM QSYS2.SYSCOLUMNS WHERE TABLE_NAME = 'CLIENTES' AND TABLE_SCHEMA = 'MANEL' Observe vertical orientation. Column 1 Column 2...

    I40075 pointsBadges:
  • Difficult SQL query, is this possible?

    Two tables, First Table --FN---LN----Reasons John | Doe | 6 | Jane | Doe | 2 | ----------------- That's the end of the first table. Second Table ---Reason----Reason Detail----- 2 | Invalid SSN 4 | Invalid Date Of Birth -------------------------------------- That's the end of the second table....

    David Phillips35 pointsBadges:
  • sql query

    any one explain this query: select regexp_substr(char_name,'[^,]+',1,level)as row_id from char_change connect by level<=(select length(replace(char_name,',',null)) from char_change); this query is used to get the string value and print the row wise.

    Gowriking65 pointsBadges:
  • Avoid Dulpicacy while entering Data in SQL db using VB6 as front end

    Iam beginner in Vb & SQL. I am entering data like MemberName(txtMemberName.text) in sql database through VB6 front end form. I can enter same data in this field. Can any body help me in avoiding the duplicacy of the data. Following is my code on Save button :- Private Sub btnSave_Click() If...

    ITAdministrator5 pointsBadges:
  • SQL Update not Working using two files

    I have attempted to update one file with data from another but I am getting two different errors depending on how I enter my statements. I used information from this site as a reference for these statements but I must be doing something wrong. UPDATE DABCON2/ACTPHY01 A SET A.B1N4CD = (SELECT...

    dab77780 pointsBadges:
  • New Contest: ASK, Answer and win some Amazon.com gift cards

    It's that time again -- a chance to win an Amazon.com gift certificate based on your activity in the IT Knowledge Exchange community! Remember: the more you ask, answer and discuss questions, the more Knowledge Points you will earn. (Only valid questions, answers and discussions will be counted...

    ITKE54,920 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